Neal, what does your connection string look like ?
If you're using an mdw file, it should look like :
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System
Database=system.mdw;"
Bookmark this page :
http://www.connectionstrings.com/
and check the connection string variations for Access MDB's.
Juan T. Llibre
ASP.NET MVP
ASP.NET FAQ :
http://asp.net.do/faq/
=============================
"Neal" <Neal@discussions.microsoft.com> wrote in message
news:398D3B40-7327-44B2-B79C-E448072B7F6B@microsoft.com...[color=blue]
> Hi All
>
> I am trying to connect from ASP.Net app to an Access Db.
> 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 don't want and finding documentation on this especially
> removing that is like expecting a miracle..
>
> ie
> Q1 How do Iresolve these errors on one mdb only (Access 2000, on Xp sp2
> OS)and connect to the db
> Q2 How do I get rid of the whole permissions, / login screen security.
>
> TIA
> Neal
>
> --
> Neal Rogers
> University of Cape Town[/color]
