We have a team that uses Access 2003 database. They have Front end application and backend application. They want my team to host their backend in our SQL Server 2008 Database. They are expanding and also want to take advanced features of SQL Server for data retrieval, analysis. Access 2003 team will use upsizing wizard in Access 2003 to migrate their tables, databases to our SQL Server database. SQL server resides in a different server, that we host and Access 2003 is in a separate environment.
Let's say access 2003 team has an application written in VB code to develop access front end, where a user typically logs in to get into their system. can we provide some sort of method for them so that they could connect to their db in our SQL server and enter data there?
Just want to know if there's a way to let them connect to our SQL server, from their Front end system like using odbc, adodb, connection string? Then both the teams can continue on checking if they could establish a connection to our SQL backend from their front end application. Thanks.
If u setup the front end right they will only connect to there tables (database) I done this with odbc and msaccess2003 point to a differance database on the same SQL server one of my server SQL one has 10 database in it and only the right frount connect to the right database
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.