No Tools menu...?

[sarah_anne]

I was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".

I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.

I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??

I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....

What's going on?!!

I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!

I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?

Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly?

 

[ghudson]

Can you delete the .ldb file? The .ldb file must be removed before you can compact the db. Search for my thread with links to the Jet Compact Utility, it works great. Or you can try to import all of the db objects into a brand new mdb file.

 

[sarah_anne]

Or you can try to import all of the db objects into a brand new mdb file.

Couldn't delete the access created file initially, but when I restarted my machine it disappeared. Tried copying all of the db objects over to a new mdb file (long painful process) and this seems to have worked. Fingers crossed I won't have to do anything further. Thanks!

 

[jrjr]

If you have not done so, make a backup

 

[sarah_anne]

Lol, done. Three times. On three different disk drives - and am making it a routine come 5:25pm that I back it up to those locations daily!

 

[jrjr]

If you are doing this manually, this may help. It should be possible to run this with scheduled tasks and pop up automatically each day...
http://www.access-programmers.co.uk/forums/showthread.php?t=85490&highlight=backup