V
Vagabond Software
Yesterday, I tried converting an Access 2.0 database file to Access 2003,
without success.
I followed the instructions from the Microsoft web-site for converting
Access files from a previous version:
http://office.microsoft.com/en-us/assistance/HP051863781033.aspx
There are a ton of forms, reports, and especially macros, but there is only
one module. I selected Compile Loaded Modules from the Run menu and saved
the database.
When I attempt to open the Access 2.0 database in Access 2003, I am prompted
to convert it. I choose to convert it and save it an alternate folder with
the same database name. I am then informed that I need to install the
Access 2.0 Converter, but it is already installed. I have now had that same
problem on-site and here in the lab.
Since I successfully converted Access 97 databases to 2003, I decided to
attempt to convert the Access 2.0 database to Access 97. Again, I am
prompted to convert the database. I agree and choose an alternate location
on the disk with the same database name. After some items are successfully
converted, I get the following error message:
"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state."
Sure enough, when I open the database in Access 97 and click a button on the
main form, I get a compile error "Sub or Function missing". Indeed, the
offending Sub-routine that is called is, in fact, not defined.
Any help or advice is greatly appreciated.
carl
without success.
I followed the instructions from the Microsoft web-site for converting
Access files from a previous version:
http://office.microsoft.com/en-us/assistance/HP051863781033.aspx
There are a ton of forms, reports, and especially macros, but there is only
one module. I selected Compile Loaded Modules from the Run menu and saved
the database.
When I attempt to open the Access 2.0 database in Access 2003, I am prompted
to convert it. I choose to convert it and save it an alternate folder with
the same database name. I am then informed that I need to install the
Access 2.0 Converter, but it is already installed. I have now had that same
problem on-site and here in the lab.
Since I successfully converted Access 97 databases to 2003, I decided to
attempt to convert the Access 2.0 database to Access 97. Again, I am
prompted to convert the database. I agree and choose an alternate location
on the disk with the same database name. After some items are successfully
converted, I get the following error message:
"There were compilation errors during the conversion or enabling of this
database. The database has not been saved in a compiled state."
Sure enough, when I open the database in Access 97 and click a button on the
main form, I get a compile error "Sub or Function missing". Indeed, the
offending Sub-routine that is called is, in fact, not defined.
Any help or advice is greatly appreciated.
carl