I need to link an application to tables in a backend database.
In the development environment I use a dev backend db with the tables linked in.
Rolling this out into a user envirnment means the backend db can be in a different location and I want to make the link automatically by running a module via an autoexec macro
I have an Access2.0 app that does this fine but am migrating the app into Access2000 to take it from a 16bit to 32bit environment.
When I use the convert facility a compile error comes up and I think it is to do with the "sys code" not being compatible.


Removing the linking module allows the conversion to take place and the app works fine in the A2000 environment.