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.