Glenda-- JetComp is an advance (though very easy to use) utility provided free from Microsoft for compacting and repairing Jet databases (included, of course, Access). JetComp will clean up and repair problems the standard Access Compact and Repair function just can't do. Download it and try it; I think you'll be very happy with the results. Not saying that's all that's wrong with your DB, but it'd be as good a place to start as any. You can find more information on it here: http://support.microsoft.com/kb/273956. --Jim -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells Sent: Wednesday, February 02, 2005 12:43 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: access I'm pretty sure no one has messed with the DB and I've never heard of JetComp. I do regular compact and repair...guess it didn't help. What will JetComp do for me Jim? -----Original Message----- From: Jim Pettit [mailto:j_e_pettit@xxxxxxxxxxx] Sent: Wednesday, February 02, 2005 06:35 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: access Glenda-- If what you say is certain -- that nobody has monkeyed with the DB -- this sounds like a typical case of corruption. Have you run JetComp (available from Microsoft) against the DB anytime recently? --Jim _____ =20 << ella for Spam Control >> has removed 14010 Spam messages and set aside 0 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com=09 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************