Sure enough, they do have MS ACCESS DSN-less connection for MS Access support. The string they provide is

"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("../databases/YOURDATABASE.mdb")

They provide defining paths:
Server.MapPath("/") equates to "\domain.com\public\"
Server.MapPath("/images") equates to "\domain.com\public\images"

Which I take to mean that I need to embed my site into another folder named "public".

Now, they have the following on making a database connection and viewing data...

---
Set conn = Server.CreateObject("ADODB.Connection")

Conn.Open {insert your DSN-less connection}

Set ObjRs = Server.CreateObject("ADODB.Recordset")
strSQL = "select columnname from table"
objRS.open strSQL, Conn
Do While Not objRs.EOF
     response.write(objRS("columnname") & "<br>")
     objRS.MoveNext
Loop
conn.close
set conn = nothing
---
Cross-referencing the above to TheSoccerSite connections page, I think I'd need to revise the code to correspond to what's given above. (Is this right?... and where in relationship to the "Dim MM_connTheSoccerSite_STRING
MM_connTheSoccerSite_STRING =..." lines?)

Thanx.

In TheSoccerSite, the connection string is defined in the Connections folder in the file connTheSoccerSite. By default it looks like this:

MM_connTheSoccerSite_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\Webroot\TheSoccerSite\Data
base\TheSoccerSite.mdb;"

You need to replace the physical path with the dynamic part, like this:

MM_connTheSoccerSite_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & DynamicPart & ";"

Depending on where your database resides, DynamicPart can be something like:

Server.MapPath("/databases/YOURDATABASE.mdb")

assuming you have your database in a folder called databases in the root.

Does this help?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

"The host is found" and after "Waiting for server...", I have a message that says "[Microsoft][ODBC Driver Manager] Data source name too long". I renamed the site to "TSS" and the database to "TSS.mdb" The message "Testing database connection..." flashed for less than a second but the database tables, etc. are still not showing in the Applications submenu of the Databases menu...
Definitely progress, but I'm trying to figure out what's keeping it from reading the database file

Where are you encountering this? Run-time or design-time?

If you write the connection string using Server.MapPath, it only works at run-time, not at design time anymore.

For design-time, you can use a local connection string. Then when you're ready to roll-out, upload the database, but not the connecting string files.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.