I am looking for the connection string in the MS Access VBeditor. All i can see that looks like some sort of database connection is:

DBEngine.Workspaces(0).Databases(0)

where is the actual credentials for...

Dim dbldbl As Database

Dim rslRs, rslRs1 As Recordset

Dim sglcriteria, sglcriteria1 As String

Set dbldbl =...

Where can i find the ODBC tools? I am a newbie so i require a little bit more details.

I set it to include tcp and pipe connections but i get the same error.

I set it to local connections only. I am running the database and MS access application on the same machine under the same user (me).

The user has the required database set to default.

The user mapping includes the required database.

I have listed links to screenshots for both, take a look. Any help is great,...