Delete a System.ldb file?

[Guest]

Access is not allowing any user to open any database on the system or
network. THe message is 'Could not use 'Admin'; file is already in use.
There are no related [databasename].ldb files on the system or in the network
folders, but htere is a System.ldb file in the Program files\common\system
folder. THat file has one entry. The entry lists the user name 'Admin'.
Would deleting that .ldb file unolock the system function? How do I delete
it? (Are system administrator rights required?)

 

[Guest]

I would not delete but rename it and see if it makes a difference.

 

[John Vinson]

Access is not allowing any user to open any database on the system or
network. THe message is 'Could not use 'Admin'; file is already in use.
There are no related [databasename].ldb files on the system or in the network
folders, but htere is a System.ldb file in the Program files\common\system
folder. THat file has one entry. The entry lists the user name 'Admin'.
Would deleting that .ldb file unolock the system function? How do I delete
it? (Are system administrator rights required?)

That's it. Someone has apparently (mistakenly) attempted to open the
SYSTEM.MDW file. You should be able to delete the .ldb (and you may
indeed need SA to do so, though that means that someone with SA caused
the problem in the first place).

John W. Vinson[MVP]

 

[Guest]

I'll be tryning the deletion route shortly and let you know how it comes out.
Thanks for the confirmation.

Access is not allowing any user to open any database on the system or
network. THe message is 'Could not use 'Admin'; file is already in use.
There are no related [databasename].ldb files on the system or in the network
folders, but htere is a System.ldb file in the Program files\common\system
folder. THat file has one entry. The entry lists the user name 'Admin'.
Would deleting that .ldb file unolock the system function? How do I delete
it? (Are system administrator rights required?)

That's it. Someone has apparently (mistakenly) attempted to open the
SYSTEM.MDW file. You should be able to delete the .ldb (and you may
indeed need SA to do so, though that means that someone with SA caused
the problem in the first place).

John W. Vinson[MVP]