From: "Chris O'C via AccessMonster.com" <u29189@uwe>
Date: Tue, 22 Apr 2008 23:01:08 GMT
Split the database and distribute a copy of the front end to each user to
save on his own hard drive. The top reason for corruption is multiple users
sharing an unsplit database file.
Chris
Microsoft MVP
Fred wrote:
I have a multi-user application that executes on a runtime on a file server.
I didn’t split the database by “front-end” (forms) and “back end” (data).
When there is no corruption, the database runs smoothly for days. On
occasions, the database gets corrupted thereby needing a manual “compact and
repair” process.
The Error Message is:
"The database “\\Land\Copy (3) of Property.mdb“ needs to be repaired or
isn’t a database file. You or another user may have unexpectedly quit
Microsoft Office Access while a Microsoft Office Access database was open. Do
you want Microsoft Office Access to attempt to repair the database?"
Re: More query questions re: keywords ... I left out a closing quote mark in the query after the word "Active". ... As far as your database problem, I am shooting in the dark. ... > & it gave me an error message that I needed. ... > table in Excel (to keep it free from any possible corruption) and imported it ... (microsoft.public.access.queries)
Re: More query questions re: keywords ... I want it to only search active records.... & it gave me an error message that I needed. ... I started a brand new database from scratch. ... table in Excel (to keep it free from any possible corruption) and imported it ... (microsoft.public.access.queries)
Re: Attempt to fetch logical page ... You have a corruption in your database.... Second, if you are on SQL Server 2000, check the specific recommendations for your error. ... This error occurs when Microsoft® SQL ServerT detects database corruption....execute DBCC CHECKDB to determine the extent of the damage. ... (microsoft.public.sqlserver.server)
Re: 2007 wont open older format database ... Don't assume that she isn't telling me about the error message.... have been to her desk and got the error myself that mentioned that it ... "This database is in an unrecognized format. ... Upgrade your version of Microsoft Office Access to the current one, ... (comp.databases.ms-access)
Re: Do Transactions guard against corruption? ... when the database is opened and closed. ... meant by 'corruption'....Transactions have NEVER been designed as safeguard for those previous ... not used by Access to protect the structure of the database. ... (microsoft.public.access.modulesdaovba)
