|
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
In Excel, when I go to Data, Get External Data, Create New Database Query, locate my Access database on my school’s network drive, and click OK, I get a message that says “This data source contains no visible tables”. The database runs fine when opened in Access.
What does this message mean, and how do I correct it? Many thanks.
jaleotta
Do you have access to these tables? I am not familiar with MS-Access, but they may have some privileges and restrictions set on some of the tables and that is why you are getting this error message.
Best of luck
Wassim 
There are two possibilities that give this symptom which I have experienced. The first is that someone has the database open exclusively, make sure that users uncheck the exclusive access box when opening the Access file. The second is that the permissions set on the Access database need to be amended using the security permissions menu in the opened Acess database. Have the administrator change these permissions for the tables that you wish to connect to. HTH
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
