If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Frontend to SQL database
I used the upsize Wizard to create the SQL database and use my .mdb
for the frontend. Now we have moved SQL server to a new server. I have figured out how to move the database, but I don't know how to tell Access where the new location is. Thanks. |
#2
|
|||
|
|||
Access Frontend to SQL database
On Wed, 10 Jun 2009 12:03:14 -0700 (PDT), jfrasier
wrote: I used the upsize Wizard to create the SQL database and use my .mdb for the frontend. Now we have moved SQL server to a new server. I have figured out how to move the database, but I don't know how to tell Access where the new location is. Thanks. You'll need an ODBC link to the current SQL instance: Start... Control Panel... Administrative Tools... Data Sources(ODBC) on my Windows version, it may be somewhere else on yours. You can then delete all the table links in your current frontend and use File... Get External Data... Link, and select ODBC from the "files of type" to link to the ODBC connection that you defined. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Access Frontend to SQL database
Thank you so much. That worked great.
Jane On Jun 10, 1:33*pm, John W. Vinson wrote: On Wed, 10 Jun 2009 12:03:14 -0700 (PDT), jfrasier wrote: I used the upsize Wizard to create the SQL database and use my .mdb for the frontend. Now we have moved SQL server to a new server. I have figured out how to move the database, but I don't know how to tell Access where the new location is. Thanks. You'll need an ODBC link to the current SQL instance: Start... Control Panel... Administrative Tools... Data Sources(ODBC) on my Windows version, it may be somewhere else on yours. You can then delete all the table links in your current frontend and use File... Get External Data... Link, and select ODBC from the "files of type" to link to the ODBC connection that you defined. -- * * * * * * *John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|