file missing security tab
I have a user who runs an access db that at, what seems to be random intervals, locks up and become inaccessible. the file is stored on a files server. The user has tried
1. Running the file directly from the server
2. copying and running on it his local machine
but once the file is locked, we can't move it, rename it, nor delete it. I tried right clicking on it and the security and sharing tab is gone.
any ideas on why this could happen and how can I restore the permission on this file.
thanks
Mike
1. Running the file directly from the server
2. copying and running on it his local machine
but once the file is locked, we can't move it, rename it, nor delete it. I tried right clicking on it and the security and sharing tab is gone.
any ideas on why this could happen and how can I restore the permission on this file.
thanks
Mike
asavener
Old version of Access? I thought all the new versions used Microsoft Database Engine (MSDE).
ASKER
access 2003
See if this KB helps
http://support.microsoft.com/kb/320081
http://support.microsoft.com/kb/320081
A persistent .ldb file could indicate several things. The most common is an Access app that is abruptly ending (normally due to dropped network connections, or user interaction) or a corrupt database.
If you're dealing with a dropped network connection there's little you can do about it except fix the problem with the connection.
If you're dealing with a user who is not properly exiting the app, then you can apply a little upper-level management.
If you're dealing with a corrupt database, then you first make a COPY of your db, then you should:
1) Build a new, blank database
2) Import everything into that new database
3) Open the VBA editor
4) Click Debug - Compile. Fix any errors that crop up.
5) Click Tools - Database utilities - Compact & Repair
This will often fix a corrupt database ... if it does not then IMMEDIATELY make a copy of the the database and post back here.
<I thought all the new versions used Microsoft Database Engine (MSDE)>
There are no versions of Access which use the MSDE by default ... all versions of Access use the Jet database engine, although they can all use the MSDE (which is now named SQL Server Express, BTW), SQL Server, or any other ODBC data source for which there is a driver.
If you're dealing with a dropped network connection there's little you can do about it except fix the problem with the connection.
If you're dealing with a user who is not properly exiting the app, then you can apply a little upper-level management.
If you're dealing with a corrupt database, then you first make a COPY of your db, then you should:
1) Build a new, blank database
2) Import everything into that new database
3) Open the VBA editor
4) Click Debug - Compile. Fix any errors that crop up.
5) Click Tools - Database utilities - Compact & Repair
This will often fix a corrupt database ... if it does not then IMMEDIATELY make a copy of the the database and post back here.
<I thought all the new versions used Microsoft Database Engine (MSDE)>
There are no versions of Access which use the MSDE by default ... all versions of Access use the Jet database engine, although they can all use the MSDE (which is now named SQL Server Express, BTW), SQL Server, or any other ODBC data source for which there is a driver.
MS Access files, *.MDB are dynamic files which are locked by MS Access for ever as long as it runs. The mdb file is locked for read, write or modify.. I you want to copy those files, you may stop MS Access and then copy or move. and also you will be able to see the security page.
<I tried right clicking on it and the security and sharing tab is gone.>
This could be because the machine is set for "Simple File Sharing" ... you'll have to untick this to see the Security and Sharing tab (it's in the View - Folder Options section
This could be because the machine is set for "Simple File Sharing" ... you'll have to untick this to see the Security and Sharing tab (it's in the View - Folder Options section
ASKER
is there a way to repair the permission on the file? I can't delete, move, rename.
Reboot the server to remove any file lock, run scandisk, grab ownership of the file if needed, then set permissions.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@LSMConsulting
THANKS! Worked like a champ.. Not all the time can you reboot a production server to remove a lock.
THANKS! Worked like a champ.. Not all the time can you reboot a production server to remove a lock.