Access/EXcel connection

[Guest]

Hi All,

I have setup an Access database with a bunch of stuff in it. I have then
created a whole bunch of excel spreadsheets which view the data using MS
Query.

I have now secured the Access database and Excel can no longer access the
database, it says 'no permissions' and then throws up a login form. I have
typed in the username and password without success. I have also tried to
recreate the MS Query from scratch and cannot get into the database.

What am i doing wrong?

Thanks
Emma

 

[Guest]

I had the same problem and found that the problem was that excel did not have
the proper read priveldges to your database.

Make sure that the admin account has at least read access on all associated
tables and queries and also make sure that the have open/run privledges to
the database.

Regulator