I have a frontend/backend setup for a database here. We have 6 users with local copies, linked to 2 shared databases. The database used to be just one database on a shared server, but in order to eliminate continuous repair errors, I split it up this way. We STILL get the repair error on the backend - the one that houses most of the data. WHAT CAN I DO ABOUT THIS?!?!?!?!?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
STUPID BACKEND!
- Thread starter RoseV
- Start date
TPetersonFlorida
Programmer
RoseV: I have researched this problem quite extensively because we get the same thing here at my office. One of the causes of this "corruption" is the speed of the network. If the network is slow it can cause corruptions, you may want to try and place the frontends on the server in the same folder as the backend, this might eliminate the corruption on the backend but you may get corruption on the frontend, at least thats what we have learned here.
Hope this helps some. I have noticed in my experience that Access 2000 seems to corrupt quite a bit more often than the previous versions and I've been programming since Access 2.0.
Hope this helps some. I have noticed in my experience that Access 2000 seems to corrupt quite a bit more often than the previous versions and I've been programming since Access 2.0.
RoseV: While TPetersonFlorida's response is a good one and may resolve your problems, you might also want to visit the issue of user education (should be fairly easy since there are only six users). Nothing will corrupt a database as fast as abnormally ending execution while it's trying to write records. Could be as innocent as a PC suddenly losing power or as bad as an impatient user unplugging his/her machine. Just a thought.
The front end should NOT sit on the server, it should be on the user's PC.
Kicking the plug will definitely cause corruption. So will using the task manager to kill the task. And a zillion other things.
There are thousands of threads about corruption and what causes it on comp.databases.ms-access. Do a groups.google.com search for corruption cause "peter miller". You're sure to find TONS of great information that way.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Kicking the plug will definitely cause corruption. So will using the task manager to kill the task. And a zillion other things.
There are thousands of threads about corruption and what causes it on comp.databases.ms-access. Do a groups.google.com search for corruption cause "peter miller". You're sure to find TONS of great information that way.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Hi JeremyNYC:
How do you get the database backup when it goes down. My computer lost power and my database is got this Problem Error and shuts down.
Charles
Sincerely,
Charles
How do you get the database backup when it goes down. My computer lost power and my database is got this Problem Error and shuts down.
Charles
Sincerely,
Charles
Charles, suggest something like the following:
1. Load a database other than the corrupt one
2. Unhide the database window if necessary and close it
3. Point to Tools|Database Utilities|Compact and Repair Database...
4. Point to the corrupt db and
5. Click Compact
That should do the trick.
1. Load a database other than the corrupt one
2. Unhide the database window if necessary and close it
3. Point to Tools|Database Utilities|Compact and Repair Database...
4. Point to the corrupt db and
5. Click Compact
That should do the trick.
I am getting this error (Microsoft Access has encountered a problem and needs to close.) and I can find no info on how to fix it. I can't even open the database rather I am trying open it or import all data to another database. I tried what you said and still get the error.
Sincerely,
Charles
Sincerely,
Charles
I've encountered a similar problem I used LDBView.exe to monitor the backend over a few weeks which in my case found a culprit computer that was corrupting the backend. In this case it was a computer that was crashing while in the database.
I have a setup of frontend and backend in the directory on a main server (around 20 users accesssing it, often at least 8 users on at one time) as this does ensure they access both files at the same speed I does beg an Issue of having to upload the frontend.
In short download the LDView.exe from Microsoft and monitor you backend, see who is corrupting you backend.
I have a setup of frontend and backend in the directory on a main server (around 20 users accesssing it, often at least 8 users on at one time) as this does ensure they access both files at the same speed I does beg an Issue of having to upload the frontend.
In short download the LDView.exe from Microsoft and monitor you backend, see who is corrupting you backend.
Charles,
Access has a problem with long path names to databases you're linking to or accessing remotely. It should allow 260 character paths, but only allows about 128. So try moving the database to the root folder and then importing.
In my case, what I was sure was intractable corruption simply disappeared, and I didn't even need to rebuild the database.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Access has a problem with long path names to databases you're linking to or accessing remotely. It should allow 260 character paths, but only allows about 128. So try moving the database to the root folder and then importing.
In my case, what I was sure was intractable corruption simply disappeared, and I didn't even need to rebuild the database.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Nothing works I still get the error. This started after my computer shut down improprly. Now I have no one else on the database and it still gives the error. Is there anyway to extract the data from the database, or a program that can fix it?
Sincerely,
Charles
Sincerely,
Charles
Charles,
Search the Knowledge Base on support.microsoft.com for "jetcomp". This is a utility that can sometimes fix corrupted databases. Be careful to get the version appropriate for your version of Access.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Search the Knowledge Base on support.microsoft.com for "jetcomp". This is a utility that can sometimes fix corrupted databases. Be careful to get the version appropriate for your version of Access.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
I tried it ant the jetcomp threw an error. I am using access 2002 format. Do you have any idea what version I should use?
Sincerely,
Charles
Sincerely,
Charles
I don't know what you mean by "access 2002 format", but it's just a matter of reading the KB article carefully. Every one of them ends (and usually starts) with "The information in this article applies to:" and a list of products.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Rick,
In AXP you can use either Access 2000 file format or Access 2002 file format. The version is indicated in the title bar of the database window.
=========
Charles,
Check out It's the best set of resources I know of for dealing with corrupt databases. At the end, Tony lists some data recovery companies. Peter Miller, at is the first one listed. I don't know the other shops, and I've never done business with Peter, but I have dealt with him on some seriously odd corruption issues, and he figured out exactly what was going on.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
In AXP you can use either Access 2000 file format or Access 2002 file format. The version is indicated in the title bar of the database window.
=========
Charles,
Check out It's the best set of resources I know of for dealing with corrupt databases. At the end, Tony lists some data recovery companies. Peter Miller, at is the first one listed. I don't know the other shops, and I've never done business with Peter, but I have dealt with him on some seriously odd corruption issues, and he figured out exactly what was going on.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
Thanks guys for all your help I had to restore from a backup and reenter some data, but I am up and running.
Sincerely,
Charles
Sincerely,
Charles
Jeremy,
Thanks for the clarification. I've had Office XP Developer sitting on the floor at home for two years but haven't installed it yet. (I've been meaning to get a new server, and I didn't want the hassle of switching activations.) So I'd never heard of this alternate format choice.
Rick
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Thanks for the clarification. I've had Office XP Developer sitting on the floor at home for two years but haven't installed it yet. (I've been meaning to get a new server, and I didn't want the hassle of switching activations.) So I'd never heard of this alternate format choice.
Rick
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
