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

[Guest]

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

 

[TC]

First, check that all potential users of the Access database have full
read/write/create/delete permissions to the folder where the database
is.

Second, if you get a username/password box when you double-click any
MDB file, this just means that you added a password to the Admin user
of the PC's default workgroup information file. To remove that box, you
need to start Access, log in as any member of the Admins group, and
clear the password from the Admin user.

Access security is quite hard to learn initially. It's a big mistake to
mess around with it, unless you follow a written list of explicit
instructions - adding & omitting nothing. Try the Access Security FAQ,
often referenced in this newsgroup.

Not sure wat you mean by "all permissions under admins group for the
whole bang shoot and still no joy". Access security problems are very
hard to diagnose by remote control. You need to be much clearer than
that, for people to help.

HTH,
TC