Hi Al
instead of
Password="password";
try adding
Jet OLEDB:Database Password="password";
to your connection string...
vas
> Hi All
>
> Thanks for the suggestions, but I still couldn't get it to work.
> I'm just going to find another solution to the problem.
> but thanks again for the help
>
> Al
>
> > I use Access 97, the following code works for me.
> >
> > strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > strConnect = strConnect & " Data
> Source=c:\Database\training\secure
> > training.mdb;"
> > strConnect = strConnect & " Jet OLEDB:System
> > Database=c:\database\training\system.mdw;"
> > strConnect = strConnect & " User
> ID=""user"";Password=""password"";"
> >
> > session("strConnect") = strConnect
> >
> > Notice user must be in the workgroup file, and his password, I do
> protect the database.
> > If you don't protect your database use
> > strConnect = strConnect & " User
> ID=""Admin"";Password="""";"
> > Also, it is better to tell the system where the workgroup file is.
> >
> > Let me know if this works for Access 2000.
> >
> > Med
> >
> > > Hello
> > >
> > > I'm tring to read from an Access 2K database, but I'm unable to
> connect
> > > to it. I get the follwwing error:
> > >
> > > Microsoft JET Database Engine (0x80040E4D)
> > > Cannot start your application. The workgroup information file is
> missing
> > > or opened exclusively by another user.
> > >
> > > I've created the workgroup information file, it resides in the same
> > > directory as the database and the ASP script. The file is not open,
> so
> > > I'm wondering what is going on here.
> > >
> > > Thanks
> > >