Converting Access 95 to Access 2000-2003

[Guest]

How can one accomplish this?

 

[Douglas J. Steele]

Open the database in the newer version of Access, and accept its offer to
convert.

Unless you've got some really funky stuff in your database, you shouldn't
have any problem.

 

[Guest]

What would constitute "funky stuff"? I have tried to
convert it but I receive an error message:

"THe Visual Basic for Applications project in the database
is corrupt."

I followed the instructions and compacted and repaired,
but it made no difference as fas as trying to convert it.

thanks in advance

 

[Allen Browne]

That's not at all surprising for an A95 db.

Using A95, try decompiling a copy of the database by entering something like
this at the command prompt while Access is not running. It is all one line,
and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact the database, and try the import again.

If that does not fix the problem, try creating a new (blank) database in
A95, and then importing everything (File | Get External | Import).

If that still won't convert, you may need to use the undocumented SaveAsText
and LoadFromText in A95 to rescue the objects.

 

[Guest]

Unfortunately, there is no decompile function in my
version of A95.

-----Original Message-----
That's not at all surprising for an A95 db.

Using A95, try decompiling a copy of the database by entering something like
this at the command prompt while Access is not running. It is all one line,
and include the quotes:
"c:\Program Files\Microsoft

office\office\msaccess.exe" /decompile

 

[Douglas J. Steele]

Did you try following Allen's example (on a copy of your database, of
course)?

It is an undocumented feature. (OTOH, you could be right: I never really
used Access 95, given how poor a version it was)