February 23, 2009 at 2:58 pm
We have a third party application that uses an Access front end but the tables in Access are pointed to our MSSQL Server. I have no idea how these are pointed to our server and am looking for any help I can get to figure this out. We are going to be upgrading our servers and I need to know where to fix this connection string out as we will be assigning the new server a differenty name.
February 23, 2009 at 3:03 pm
Look for the Linked Table manager within the Access DB. Should allow you to redirect "regular" linked tables, assuming nothing in the code is updating them (there were various reasons you might care to rebuild your linked tables every once in a while, so there might be some code doing just that somewhere in the Access App.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 23, 2009 at 3:05 pm
Just be sure NOT to ignore any of the prompts you might get about "show my the primary key/unique value combination" (I must admit to not remembering what the actual prompt say).
In short - in order for a table to be updatable from Access, it needs a PK. If it can't identify one in the linked table, it will ask you; if you don't give it one, or don't give it a GOOD one, you may find that the table is de facto read only.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 24, 2009 at 4:44 am
The tables will only be linked if the Access database is in MDB/MDE format
If it's in ADP format, you need to go to "Connection" on the File menu - here you specify the name of the server, the database to connect to, and the security credentials
April 7, 2009 at 6:16 am
dwjongbloed (2/23/2009)
We have a third party application that uses an Access front end but the tables in Access are pointed to our MSSQL Server. I have no idea how these are pointed to our server and am looking for any help I can get to figure this out. We are going to be upgrading our servers and I need to know where to fix this connection string out as we will be assigning the new server a differenty name.
Press Alt-F11 for the VBA environment, then press Ctrl-G for the Immediate Window, then type this in and hit ENTER:
?CurrentDb.TableDefs("one of your linked table names").Connect
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply