Access Database with Linked Tables cannot be deleted

[tful282]

I have an Ms 2000 access database which is being used to select and union data from 2 different datasources- one sql server, one oracle. The tables are linked using ODBC datasources.
The access db is placed on a network share and used as a source for a (crystal) report. The report will not run correctly- it doesn't fail, it just runs forever- after this happens I want to remove the database and make some changes, however I cannot delete (or change) the database- I get a sharing violation error message. There is no .ldb file.
I have full privileges on the share and I am the database owner.
Does anyone have any suggestions as how I can regain control of my db?

 

[OnTheFly]

I know this is a 'cliche' answer but I have run into this before. Have you tried rebooting both the machine the data file resides on an the machine that was accessing the data from Crystal?

Sorry, that's all I have. Hopefully the database did not get corrupted but that should not cause this type of error. Usually it means there is a dangling reference some where in the system and rebooting usually clears this out.

Good Luck.

Hope this helps.

OnTheFly

 

[tful282]

Unfortunately it is on a production server.. I'll see if we cant reboot it this weekend.

Thanks...