Linked tables became hidden tables on Server Crash

  • Thread starter Thread starter FrankG@fnis
  • Start date Start date
F

FrankG@fnis

I hope someone can help me on this.

I have an Access 2007 db that in a module creates a set of links to some
Microsoft Great Plains Inventory, Purchasing and Sales Order Processing
tables. I have been using this database for several years without a problem--
UNTIL THIS MORNING.

Our Server, on which my Access db crashed during the update with Great
Plains. After the server came back up, Access said that it had become
unstable and needed to repair itself. What has happened is I am getting
Permission Errors 3033 saying that I cannot Delete the object and it is
listing one of the tables from GP.
After a lot of searching I found out that it had created hidden tables out
of the 5 of my linked tables. When I select one of the tables and click
Delete, it says that I don't have permission. It is now an "nonlinked" hidden
table that cannot be deleted.

I have opened the db exclusively, but still it won't let me delete it.

Does anyone have any idea of how to get these tables out of there? I can't
rename them. I can't make them unhidden or even open them.
Any help anyone might give will be deeply appreciated.
 
Hi Frank,

Do you have a backup. If so, go with that. There is clearly
corruption there. If you do not have a backup, how about creating a new
database, importing all but the Great Plains table links, then creating new
links to them? Make sure your references (VBA Editor, Tools menu,
References) in the new one match the ones in the old one.

Clifford Bass
 
Back
Top