[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MDE File Getting Corrupted

Posted on 2005-05-17
1
Medium Priority
?
305 Views
Last Modified: 2013-12-05
I have an access 2000 database "compiled" to an MDE.

Every so often, my users get the message that the database is locked by "admin" on another computer.  This would happen 20 times per day as an MDB, not it happens 6 - 7 times per month.

All the tables are linked tables (SQL Server).

The MDE file is located on the server.  I have to disconect all users and compact/repair the mde to correct the problem.

What could be causing this?

Thanks in advance for any suggestions.
0
Comment
Question by:bnhcomputing
1 Comment
 
LVL 39

Accepted Solution

by:
thenelson earned 375 total points
ID: 14017899
Try moving it to the local computers so each user has their own copy.  I have a sample DB that would automate upgrading the FE to each user from the server if you are interested.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question