bummer.... Now that you will have it recreated, you might conceder splitting the database into a front end and back end. On a single file, multi user database, Access really does not do a good job of keeping track of itself. If the database is split into a 'data' back end each user can have their own copy of the 'interface' front end. Access 2k has a wizard for splitting a database. In a split database all the back end needs to keep track of is the data, not the forms or reports or queries. Be aware that splitting a database does not make a client sever database. Although it will look like it and act like it, it will not be. -Anthony -----Original Message----- From: Higley, T.J. [mailto:TJHIGLEY@xxxxxxxxxxx] Sent: Thursday, May 16, 2002 4:40 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Corrupted Access Database Neither idea worked, so we restored an older version from tape. He's busy reconstructing the past 2 day's work. Thanks, everyone, for trying! tj -----Original Message----- From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx]=20 Sent: Thursday, May 16, 2002 1:57 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Corrupted Access Database When Access starts it creates a LDB file that keeps track of the users in the database. When the last person is out of the database the LDB file is destroyed. Sometimes this file is left hanging and it will not let any one back in. The LDB file is in the same directory as the MDB file the name is the same and as the MDB with a LDB extension. If the file exists with no user in the database that might be your problem. You can delete the file, just don't do this if someone is in a database. If you can't open the file itself, create a new Access application and try to import the objects from the broken database.=20 This link from MS might help too http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;Q209137 -Anthony -----Original Message----- From: Higley, T.J. [mailto:TJHIGLEY@xxxxxxxxxxx] Sent: Thursday, May 16, 2002 2:06 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Corrupted Access Database The DB was created using Access 2000. It is a single-file DB that resides on a file-sharing server. 3 or 4 people have access to it. tj -----Original Message----- From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx]=3D20 Sent: Thursday, May 16, 2002 12:09 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Corrupted Access Database tj- A couple of questions Is the database on a server? Is the database split into a front end / back end application or is it a single file? What version of Access? -Anthony -----Original Message----- From: Higley, T.J. [mailto:TJHIGLEY@xxxxxxxxxxx] Sent: Thursday, May 16, 2002 12:58 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Corrupted Access Database I have a user whose database has become corrupted. At least, I think that's what's happened. Here's the error message: "The database (filename) needs to be repaired or isn't a database file. You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open." It then attempts to repair the database but I get this message: "Not a valid password." He's sure the password is correct. I believe him since Access responds differently if I type in an incorrect password. It accepts the correct password and attempts to repair; it won't accept an incorrect password at all. I've tried Tools, Database Utilities, Repair to no avail. I've also tried Convert. Again, no luck. Ideas? tj TJ Higley Customer Support Specialist Taylor University - Upland, IN (765) 998-4044 ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso ************************************************************* ************************************************************* PLEASE READ!!!! You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe" (without the quotes). Do not put unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps prevent the function from working. To change your email settings to digest or vacation (no mail), visit the group's homepage for full instructions. //www.freelists.org/webpage/mso *************************************************************