Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 16th, 2008, 07:52 AM
Registered User
Join Date: Oct 2007
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked tables to an unavailable SQL server

I'm working on an access database for another company and testing it on our sql server. but i can't access machines on their network very easily. is it possible once i have it working to replace the connection string in my database for each table so it connects to their server and then send the database to them and it works?

the tables will exist on their server already.

Old January 16th, 2008, 09:17 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

If these tables are only being used for transactions (best way) then put the connection string in a module and and make a call to it every time you want to do a transaction, then all you have to do is change the string in the module - assuming the table names are the same and the table owner is the same.

If these are linked tables, you may have to delete the tables and re-establish the links. There have been some recent posts about managig linked tables. I generally don't use linked tables.



Look it up at: http://wrox.books24x7.com

Similar Threads
Thread Thread Starter Forum Replies Last Post
Locking in Access DB linked to SQL Server backend gibbers Access 3 April 24th, 2007 03:20 PM
Accessing Linked SQL tables in Access seran128 Classic ASP Professional 0 April 3rd, 2006 10:39 PM
Access MDB with a Linked SQL Server Table..... timmaher Classic ASP Databases 0 September 28th, 2005 03:57 AM
Unavailable download code for VB.Net & SQL Server bamboat_3 VB.NET 2 September 2nd, 2004 09:34 AM
Access and update linked SQL Server 2000 table Lizu Access 9 May 10th, 2004 12:42 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.