G
Guest
How can one accomplish this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
convert.
Unless you've got some really funky stuff in your database, you shouldn't
have any problem.
G
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
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
A
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.
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.
G
Guest
Unfortunately, there is no decompile function in my
version of A95.
version of A95.
office\office\msaccess.exe" /decompile-----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
D
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)
course)?
It is an undocumented feature. (OTOH, you could be right: I never really
used Access 95, given how poor a version it was)