Linked tables missing

J

JWhite

I have a database (Access 2007) that was developed to run general queries and
reports that I have to create for a variety of users. The vast majority of
the tables in this database are linked via an ODBC Driver to the Microsoft
Great Plains application. For some reason all of a sudden a few of the
previously linked tables seem to have disappeared. We have a back up from
about 1 week and a half ago that shows them still there at that time.
However, when we try to import the link again and change the name of the
linked table to how it read before we lost it, the database seems to think
it's still there. It recognizes that there is another table by the same name
and asks if I want to overlay the previous table. When I click "yes" I get
the following error message: "You don't have permission to delete 'table
name'". I have tried compacting and repairing the database but nothing
changed. I also refreshed all the links. Again, no change. Has anyone
heard of anything like this before? The only way I can think to resolve this
is to start a new database and import all the objects. It's a pretty big
database though and I'd rather not do that if there is an alternative.
Thanks in advance for any help anyone can provide.
 
A

Arvin Meyer [MVP]

JWhite said:
The only way I can think to resolve this
is to start a new database and import all the objects. It's a pretty big
database though and I'd rather not do that if there is an alternative.

Actually, that's one of the better ways to get rid of corruption problems.
It should only take a few minutes. Select everything but the tables and
import them into the new database. Then select any local tables and import
them. Then all you need to do is start a new link from the GetExternalData
menu and link everything at once and link them all. Even a database with a
100 tables out of 120 on the server can be done in under 5 minutes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top