can't successfully repair db what now

J

Janette

Hi,

I am desparate not to have lost several days worth of development. My adp
database file wont open. I get a Microsoft message, wanting to send an error
report. It suggests repair open database and restart ms access. Which I let
it do, and then it comes up with the same message again.

Is there any way of getting access to the VB code at the very least, so I
can copy it into an old version and continue?

HELP!!!!

Thanks
Janette
 
T

Tony Toews

Janette said:
I am desparate not to have lost several days worth of development. My adp
database file wont open. I get a Microsoft message, wanting to send an error
report. It suggests repair open database and restart ms access. Which I let
it do, and then it comes up with the same message again.

Is there any way of getting access to the VB code at the very least, so I
can copy it into an old version and continue?

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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
 
J

Janette

Hi Tony,

Do the steps outlined at this site also apply to *.adp files or only to
*.mdb files. As I haven't lost any tables or data, I have only lost the vba
code that sits behind the reports and forms. The tables are hosted on a SQL
Server database.

Thanks
Janette
 
T

Tony Toews

Janette said:
Do the steps outlined at this site also apply to *.adp files or only to
*.mdb files. As I haven't lost any tables or data, I have only lost the vba
code that sits behind the reports and forms. The tables are hosted on a SQL
Server database.

The steps, for the most part, should work with .adp files. Besides
if you make a copy of the file, which should be your very first step,
you can't get into any more trouble than you currently are in.

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
 
Top