Corrupt database

[Ogelema]

Hello all,

I was working on an Access 2000 file, and tried to save some work I had been
doing on a form. I then got the response that the object could not be saved,
following which I have not been able to use the database.

Whenever I open the application, and try to open the file, the following
happens
1. A dialog box comes up with the following caption "The database is Read
Only You wont be able to save changes made to data or objects definitions in
this database".
2. On pressing the OK button on the dialog box, another dialog box comes up
with the following message "The Visual Basic for Applications project in the
database is corrupt"
3. My switchboard form opens up, with only the caption displayed.

I will be looking forward to your assistance with this problem?

Ogelema

 

[Brian]

Hello all,

I was working on an Access 2000 file, and tried to save some work I had been
doing on a form. I then got the response that the object could not be saved,
following which I have not been able to use the database.

Whenever I open the application, and try to open the file, the following
happens
1. A dialog box comes up with the following caption "The database is Read
Only You wont be able to save changes made to data or objects definitions in
this database".
2. On pressing the OK button on the dialog box, another dialog box comes up
with the following message "The Visual Basic for Applications project in the
database is corrupt"
3. My switchboard form opens up, with only the caption displayed.

I will be looking forward to your assistance with this problem?

Ogelema

You could try the usual steps for recovering a corrupt database. Take a
look here:

http://members.iinet.net.au/~allenbrowne/ser-47.html

I've encountered this corrupt VBA project message a few times, and I've
never managed to fix the database, it's always been necessary to restore a
backup. You do have a backup, right?

 

[Tony Toews]

Whenever I open the application, and try to open the file, the following
happens
1. A dialog box comes up with the following caption "The database is Read
Only You wont be able to save changes made to data or objects definitions in
this database".

This is interesting. You get the same (or similar) message when a MDB
has the read only attribute set after copying from CD. Could you
double check that that attribute isn't set on the file.

2. On pressing the OK button on the dialog box, another dialog box comes up
with the following message "The Visual Basic for Applications project in the
database is corrupt"

I'd start with a decompile. Decompile or how to reduce Microsoft
Access MDB/MDE size and decrease start-up times
http://www.granite.ab.ca/access/decompile.htm

Make a backup first.

If that doesn't work then try importing from that MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm