Migration to SQL Server

Hi everyone,
We have Desktop Application developed in Access 2003/2007. We have more
than 50 clients using this application and now we want to convert back end to
SQL Server while keeping Access as front end.

I could move all the tables to SQL Server and link to MS Access but my
question is we don't know the location of sql server at client's location, so
it needs to be dynamic. My program should ask for server information and link
all the tables. In addition, every time it should check if connection is
valid or not and if not valid relink all the tables.

In some instances we have 15 users working off same backend database, so
need to take care of locking issues as well.

Any guidance would be appriciated.

Thanks,
MP

--
kathy montoya


"MP" wrote:

Hi everyone,
We have Desktop Application developed in Access 2003/2007. We have more
than 50 clients using this application and now we want to convert back end to
SQL Server while keeping Access as front end.

I could move all the tables to SQL Server and link to MS Access but my
question is we don't know the location of sql server at client's location, so
it needs to be dynamic. My program should ask for server information and link
all the tables. In addition, every time it should check if connection is
valid or not and if not valid relink all the tables.

In some instances we have 15 users working off same backend database, so
need to take care of locking issues as well.

Any guidance would be appriciated.

Thanks,
MP