where is the connection string defined?

M

Maggie

hi,
I can't find the connection string properties in my database project. Where
are they defined? I was looking for a connection string , but I can't find
one. How is this done ? All of the forms are bound, so i don't know if there
is one defined. How can that be?
Very confused.
 
B

Brendan Reynolds

Is this an MDB or an ADP? If it is an MDB, are the tables local or linked?
 
B

Brendan Reynolds

In that scenario, the bound forms don't need any connection string to point
to the database. Because the forms and the tables are both contained within
the same MDB, all the forms need is the name of the table or query, or a SQL
statement. You can see this by examining the RecordSource property of the
form.

To manipulate the data in code, you can use CurrentDb to get a reference to
a DAO.Database object if using DAO, or CurrentProject.Connection to get a
reference to an ADODB.Connection object if using ADO.
 
Top