Question Any Ideas on this one...

MOTOWN44

Registered User.
Local time
Today, 10:47
Joined
Aug 18, 2009
Messages
42
We have a main database at work with hundreds of thousands of records, but it has changed in to a read only state effectively halting all our users from recording/amending etc.

Any ideas why this has happened?

90% of the data is written to the database from excel, but this has been working fine for over 2 years with no issues so I don't imagine it will be that.

Nobody should have access to it other than my team and we have code in place to disable “shifting in”.

My first guess is that someone has linked to one of our tables but I have no idea who or how to find out.

Any ideas?

Thank you
 
Actually having another database "linked" to one or more of your tables would not cause the database to be in a read only state. Linking a front-end to the back-end is the recommended way of deploying a multi user Access database application.

You did not indicate that you are using the "Split" file method for your application but if you are not, that would be the first thing to do.

My next question would be; if there any possibility that the data file has reached its file size limit? Depending on the version of Access you are using will determine the maximum file size that a database file can be and still work.
 

Users who are viewing this thread

Back
Top Bottom