Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012

    Unanswered: Access 2003 db to SQL Server 2008 db

    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.

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 8
    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

    StePhan McKillen
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts