How to see/modify connection string in MS Access 2007

[sophiamb]

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?

[PianoMan64]

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.

[NeoPa]

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 :(