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.
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.