Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: Can't Connect To Access 2K Database


Message #1 by "Vasilios Koutsoubidis" <vasilios@n...> on Thu, 19 Dec 2002 05:39:23
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
> > > 

  Return to Index