I am trying to build an ADODB Connection, and I have a few questions about the connection string.

1. Since I am developing this in Access 2000, and the code is in the Access 2000 project I am working on, why do I have to provide a hardcoded path to my database in the connection string?

2. If I really to have to hardcode the database path, is there a way to make Access get the path? I am developing on a different machine that it will be running on and I would hate to have to hardcode the path. Even if I did, there is no way to ensure that my customer won't reorganize her directories, and break it. There has to be a better way.

Thanks for your insight,
Quint

Jut use:

Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String

strSQL = "SELECT Field FROM Table

Set cnn = CurrentProject.Connection
Set rst = New ADODB.Recordset
rst.Open strSQL, cnn

The Connection property of the CurrentProject object returns a reference to the CurrentProject's ADO Connection object and its related properties.

HTH,

Bob

Thanks for the info. I was trying to use the CurrentProject object, but didn't try CurrentProject.Connection. Sometimes when I start to get frustrated with a problem, the simplest things will escape me. That's when it's time to shutdown the computer and take a break.

Thanks again,
Quint