Opening access 2003 .mdb file

[techMultilink]

Hello Everyone,

One of my client has an issue with an older access software. His software includes 5 databases and when we try to open one of them
We get the following error. The Database that you are trying to open or convert is currently in use, or you do not have permission to open it exclusively.

The file is not open. Both pc who has access to it have been rebooted multiple times. I have check the user and folder prmission they all have admin access...

What else? I have done multiple search on google with no success to a solution...

Thanks in advance for the help!

Luc

 

[lameid]

Have you tried backing up, and then running "Compact and repair"?

Next I would try creating a new file and importing everything into that.

 

[techMultilink]

How can I do a compact and repair if I can't open the database? and same thing about importing.


Thanks

 

[kray4660]

Or security has been set on it and you do not have a .mdw file for it.

 

[genomon]

Or there could be an .ldb associated that needs deletion.

Beir bua agus beannacht!

 

[lameid]

You can open access without opening the database and select compact and repair. It will prompt you to select a file and then prompt for a destination file. The original is left intact in this scenario.