Urgent....Unsecuring a mdb (access 2000)

Hi All

I am trying to connect from ASP.Net app to an Access Db.

Some background info:

If i don't specify a userid an pwd.. I get this error

The Microsoft Jet database engine cannot open the file 'C:\Documents and
Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened
exclusively by another user, or you need permission to view its data."

If i specify a userid (aspnet) no password I get

Cannot start your application. The workgroup information file is missing or
opened exclusively by another user

If I specify any other mdb on my machine...
NO Problem...???


I have subsequently used the mdw file, joined it , created an aspnet user,
all permissions under admins group for the whole bang shoot and still no joy.
??

Then used the permissions wizard and now all my db's pop up a login dialog,
which I really ...really don't want
ie
Q How do I get rid of the whole permissions, / login screen security.

Q2 Anybody have any idea why I would get these connection error messages

TIA
Neal

--
Neal Rogers
University of Cape Town
.

Relevant Pages