Database path problems

Hi

Small problem I was hoping someone would have the solution to. I’m creating an intranet site that will have about 100 users. It will check a database for users permissions but using the code below creates a problem.

set gConn=Server.CreateObject(“ADODB.Connection”)
gConn.Provider=“Microsoft.Jet.OLEDB.4.0”
lpath = “e:\DataBase\Permissions.mdb”
gConn.Open (lpath)

The code is from an asp page by the way but for some reason this works on my machine and not others, even though we’re looking at the same web page on the same server. The only thing I can think of is that on my machine E: is a mapped network drive that the users can’t have access to. Copying the database to a drive they will have access to won’t work either because, basically, they’re not allowed to see this database.

I’ve created dll’s in the past to do this kind of thing but it’s not really suitable on this system.

Does anyone have any suggestions,
RabBell.