Serious Problem with Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I created a database for users to access at the same time. However, my
colleague and I were working on the same record (putting different
information in) which created a serious problem with that record. It didn't
save any of the information either of us entered and it has replaced it with
gobbledegook. Also, every time you get to a certain field, a Microsoft Error
Report message box appears saying that Microsoft Access has to close and do I
want to send Microsoft an Error Report about it.

I have tried to go into the record and remove all the rubbish so all the
fields are blank both on the form and table but with no luck. As soon as I
get to that one field, the Error Report message appears again.

I have got a backup of the database on CDR but I didn't realise that it is
read only and I can't seem to save it back on to the shared drive.

Any help with this problem would be gratefully received.

Kind regards,

Gillian
 
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
Everything on a CDR is read only. Just copy it to the hard disk and then use
explorer to look at the properties of the file and remove the read only
attribute; it is on the right click in Explorer after you select the file.

Here's some links you may wish to review.
Splitting your Microsoft Access MDB into a front end and back end - Why?
http://www.granite.ab.ca/access/splitapp/why.htm
Split your Access database into data and application
http://allenbrowne.com/ser-01.html
 
Once you've copied the file from CDR to your hard drive, right-click on the
file in Windows Explorer and look at its properties. You should see a
"read-only" attribute being checked. Uncheck it, and you should be okay.

(This is caused by the fact that Windows marks all files on CDs as read-only)
 
Thanks to everyone who replied - I've managed to load in the backup and it
all looks Ok now.

Thanks again.
 
Back
Top