By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

How to see/modify connection string in MS Access 2007

P: 1
I am new to MS Access 2007.

I'm working with an existing application, which is running off SQL Server and need to change the connection string so it works with a different database (on the same server).

Where can I see or change the connection string?
Aug 5 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
is this a project file or is it a mdb or accdb file?

if it is a project file, you'll simply create a new bank project with exsisting data, and select that data source. then import all you queries, reports, forms, and macros and modules into the new blank project and this will allow you to connect to another data source.

PLEASE NOTE THAT THIS IS ASSUMING THE DATA STRUCTURE OF THE NEW DATA SOURCE IS THE SAME.

if it is an MDB or ACCDB file you'll simply refresh the links using the link manager and point to the alternate data source.

hope that helps,

joe p.
Aug 5 '08 #2

NeoPa
Expert Mod 15k+
P: 31,656
I believe the .Connection property of a linked TableDef will allow you to see and change the connection string.

NB. Changing it doesn't relink directly. There is a procedure that needs to be called before this is actually effected. I'm afraid I forget exactly what the procedure is :(
Aug 10 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.