Access Web Database Issue

default.asp Line 15:
MM_rsUser.ActiveConnection = MM_Conn_STRING

connAdmin.asp Line 9:
MM_Conn_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("database/Login.mdb") & ";"
'MM_Conn_STRING = "dsn=classified411;"

I am not sure how to use a "full path" for this string.
I have tried the "http://www.mydomain.com/Login/Database/Login.mdb"
and the the error states I am using invalid characters.

The string I included above for the connAdmin.asp is the same string as the level 1 login ...

My guess is the string to the database needs to account for the level 1 login is in the same folder level as the default.asp for level 1 login and the level 2 is one folder level deeper.

The entire program is in the Login folder ... it has the default.asp for level 1 login in it and a connections folder as well as a database folder containing the Login.mdb.

Then also in the Login Folder is an admin folder where there is a default.asp for the second default.asp and a connections folder which is the above connAdmin.asp.

A "path" is the folders that need to be traversed to reach the file in the file system.
The one you trued ("http://www.mydomain.com/Login/Database/Login.mdb") is a URL, not a path.
A path would include the drive and the folders.

The easiest way is to find the path to teh database on the server. Using Windows simply open a window, navigate to the folder with the file and (if you have show address bar) you can simply copy the path.

eg
If all your sites on the server are in the D drive under a folder called "websites" then the path to your DB may be something like:
d:\websites\loginsite\Login.mdb

Extra Info (don't read if you don't want to :)
Using MapPath has the advantage of you not needing to know where the DB is. BUT (and it's a big but) this is a security issue as the DB MUST be in a web accessable folder (ie a folder or subfolder below the main site folder.

To clarify:
The website called MySite is in a folder called MySite. It is in a folder called Websites that is on the D drive.
In IIS (or whatever webserver) you specify the folder that contains the site - this folder and all subfolders and files are accessable from the web (or intranet). (This assumed the user specified in IIS has access to the folders which is usually will).

What I tend to do is create 2 folders, public and private, within the web site folder and point the web server at the public folder.

So we have: d:\websites\MySite\public where all the HTML files, images etc go. And this is set on the web server.
d:\websites\MySite\private is where the database goes plus any other files that the site will access BUT I don't want to be downloaded, viewed etc.

But, because the "private" folder isn't within the "public" folder you cannot use Server.MapPath. but it means the DB cannot be accessed by entering the URL to it.

Sorry for the digression, hopefully I made sense :)

>>Then also in the Login Folder is an admin folder where there is a default.asp for the second default.asp and a connections folder which is the above connAdmin.asp.

Does that mean that connAdmin.asp is in a folder called connections? or just in the folder called admin?

JagC
I am going to have to digest your information a little but I think I understand, but
in this case we have moved the site to our own server so I would know the actual local path E:\Websites\MyDomain\Login\Database ... should it be "\" or "/" ?

And why then does the level 1 work fine directed to the same folder ? Why
does the "../database/Login.mdb" work on the other server ?

cedlinx:
Yes there is a connections folder in the admin folder too ... would it have worked better to include the conn.asp on the admin default.asp page instead of the
other ? Or why did the developer use two connection files instead of one centeralized since it uses the same database ?

or maybe I should just add another database folder inside the admin folder ?
I am only storing my SuperAdmin that can access the Level 2 ?

During my tests ... I just set up another copy of the database folder and mdb in the Admin folder to test the connection string ... it worked fine !

However, one of the features I use then I login to Level 2 is review login history of users ... when I use this db of course it does not have the current table for them since it is in the other folder ...

So I tried some connection paths ...
   1) "/database/Login.mdb"               Only looks in current folder level
   2) "../database/Login.mdb"             Nope does not work on this server
   3) "//database/Login.mdb"              Nope systax issue
   4) "Login/database/Login.mdb"       Nope can not path
   5) "/Login/database/Login.mdb"      WORKS !!!!!!

Thanks