Hi all.

I am trying to figure out an access database that's written in vb.

My plan is to convert the tables into a sql server database and continue to use the front end out of access. There is one db that is named master_tables. This was converted to sqlserver db. There are a few other access interface db's, which contain the vb forms and modules, that link back to this master_tables db.

I'm running into an error that upon opening of one of the interface db's cannot find the backend data file(sqlserver). Does anyone know if you can have an interface db, linked to another master db, which tables are in sql server?

I'm also trying to figure how the vb modules and forms are written,(partially in french language), and I don't understand how the database starts. I know in access if you create an 'autoexec' macro whatever is in there will start first. What should I look for on the module side?

Thanks in advance.

Yikes. Maybe you want to rebuild this from the ground up. =)

If the tables are meant to be linked, you will need to install a DSN for the server they will be linking to. You will need to know the SQL Server name, the database name, whether you are using Windows or SQL Server authentication, and you will need crednetials on the SQL Server.

Once you do that, you can link the tables by clicking on the Tables object, then select Insert > Table > Link Table, and follow the wizard.

Once it is connected, then be sure to rename the table to its old name, or the code won't work.

Also, the code may not work if the data types are wrong and there are business rules trying to insert a different data type into the tables.

If there is any code that will run to access the tables using DAO, that will need to be converted to ADO since DAO won't work even with linked SQL Server tables.

As far as the start up options, those are usually controlled with the Tools > Start Up utility. I don't know of anyone who runs macros (or ever has for that matter) although I am sure many people do, so they would help with the autoexec issues.

As to the French language code, I am not sure how to help there. Sounds like you're reverse engineering something. Maybe you can get the requirements and dev from scratch. That might be easier if the application is not huge. I don't think the Upsizing wizard would be much help here (Tools > Database Utilities > Upsizing Wizard I think).

Did any of that help?



mmcdonal