Cannot open .mdb file

[knelson]

Greetings,

I have a database I have been developing for some time that I can no longer access. I am running windows XP and Access 2003, I am the only user and it is stored on my local system. I was tweaking some VBA code in a few of the forms and closed the file which triggered the auto compact/repair. Everything appeared normal until I tried to open it again later. Now I cannot open the file, I do not get an error message or anything. When I click on the file Access opens and stops, never actually opens the database. If I try to open the file inside Access nothing happens. I have tried importing the objects into a new DB and still nothing happens inside Access. The real wierd part to me is that outside of Access everything is accessible. I can import tables from inside Excel with no trouble, I can put a button into a blank database that opens the other database through DAO and I can see all my tables, forms, data, etc. My problem is that I do not need the data, it is just test data at this point, I need to recover the VBA code from the Forms and I do not know how to do that without being able to open the database in Access.

Here is what I have tried so far (on copies of original DB):
-Compact and Repair inside Access: Nothing happens just like trying to do anything else with it inside Access
-Opened DB holding shift: Same Problem
-Copied file to two other Windows XP/Access 2003 systems: Same problem
-Used Jet Compact: The database file compacts successfully, still cannot open in Access
-Opened Access with /decompile: Same problem, Access opens, DB does not
-Created new DB and tried to import objects: Cannot open the old DB or see its objects
-Imported data from inside Excel: No problems, all tables/queries are available and all data appears correct
-Accessed file from new DB using DAO code: Everything appears normal, I can export the modules to text fine, but I have lots of code in forms that I cannot export
-Opened other databases in Access on same machine: No problems

I've done quite a bit of searching on this and have not found the same problem listed anywhere else. I do have daily backups so I'm not completely lost, but I made quite a few changes before it died that make it worthwhile for me to try and recover the file.

Any suggestions of other things to try? Is there any way to extract the VBA code inside a form from an .mdb file outside of Access?

Thanks for any ideas!

 

[The_Doc_Man]

Tweaking VBA, eh?

OK, questions:

1. Was the form in question part of a startup form?

2. What was the VBA doing? (Event code? If so, which event and what
was to be the intended effect?)

 

[knelson]

1. No the code is not in a startup form, I don't have a startup form defined (yet)

2. Mostly event code: button clicks, check boxes, combo boxes, etc.

On one of the forms I was tweaking a couple buttons, one button which creates a query based on which check boxes are selected and a few other criteria, and the other button which then executes the query, puts the results into a specific format and exports them to a couple of files. This code was always there and I was making some modifications to it.

On another form I made a button to strip out the data and extra tables from the database and reset it to an empty sort of template. The project will eventually be a framework that a user will import data into and use the forms to manipulate and export the data to a specific format. This code was not present previously and it is the last thing I was working on before closing the database for the last time.