Login with data from 2 tables

Steve,
unfortunately there is no easy way to make it as one project.

You can create two projects (for customers and for employees) and put these projects in different directories on the server.
You should uncheck Use Server.MapPath option on Database File tab so that you work with originally database and rebuild project. Then move your database to special folder with write and read permissions on your webserver. There must be a folder at your server designed specially for storing database. To specify folder path contact admin of your web-hosting.

Then you need to move database file to that directory and update connection string accordingly.

http://xlinesoft.com/asprunner/docs/troubl...ery__errors.htm

2 projects isn't a problem...i'm just having issues with the connection string. The access database is stored in a folder called database on my designated folder on the server. Ex. http://www.site.com/web/myself/database/file.mdb What would be the connection string
also i tried without success
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\..\database\file.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

Connection string depends on where ASP files reside.

What is the URL of the application itself (or folder name).

The asp files would be at http://www.site.com/web/myself/customerlogin/login.asp

The database is in http://www.site.com/web/myself/database/file.mdb
The connection string is giving me alot of trouble and i would love any help possible

Steve,

herte is the connection string for your setup:

strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\database\file.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

PERFECT!!! thank you so much!!!