i hav make my database secured ,& my administrator user has full access to 
all objects of database.
One of my form  has in its load event following codeing;
bcon.Provider = "Microsoft.Jet.OLEDB.4.0"
bcon.ConnectionString = CurrentDb.Name
bcon.Open
when i open that form i got following error

You do not have necessary permissions to use 'c:\mydb.mdb' object.have ur 
system administrator or the person who created this object establish the 
appropriate permissions for you


now tell me wat's the wrong

waiting for ur uregent reply

Look up connectionstring and concatenate the currentDb.name() with 
a ";UserID='';pwd='' etc. The syntax will be online somewhere, or even in 
the VBA editor connectionString screen tip. As far as your database is 
concerned, any tom, dick, or Harry is trying to access your database.
 Regards,
Zak Willis

> i hav make my database secured ,& my administrator user has full access 
to 
a> ll objects of database.
O> ne of my form  has in its load event following codeing;
b> con.Provider = "Microsoft.Jet.OLEDB.4.0"
b> con.ConnectionString = CurrentDb.Name
b> con.Open
w> hen i open that form i got following error

> You do not have necessary permissions to use 'c:\mydb.mdb' object.have 
ur 
s> ystem administrator or the person who created this object establish the 
a> ppropriate permissions for you

> 
n> ow tell me wat's the wrong

> waiting for ur uregent reply

i hav used the following syntax but i got error Authentication failed 
--------
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User 
ID='';pwd='';Data Source=c:\mydb.mdb"
---------
when user start the access application,  they entered their user name and 
password ,i want that username and password to be  used in the above 
connectionstring syntax, how i do this?
waiting for u ppl reply








> i hav make my database secured ,& my administrator user has full access 
to 
a> ll objects of database.
O> ne of my form  has in its load event following codeing;
b> con.Provider = "Microsoft.Jet.OLEDB.4.0"
b> con.ConnectionString = CurrentDb.Name
b> con.Open
w> hen i open that form i got following error

> You do not have necessary permissions to use 'c:\mydb.mdb' object.have 
ur 
s> ystem administrator or the person who created this object establish the 
a> ppropriate permissions for you

> 
n> ow tell me wat's the wrong

> waiting for ur uregent reply

Hi!

Isn't that you have to indicate it in the connection string, that's to say, 
supposing your user is

User id = JerryW
Passwd  = foobar

con.ConnectionString = ".....;User ID=JerryW;pwd=foobar;Data Source=...."

That should work (I do not remeber if quotes must be there or not)...

HTH

   Claudio de Biasio
     Team 97 S.r.l.


Quoting Hanan <et_man_1980@h...>:

> i hav used the following syntax but i got error Authentication failed 
> --------
> con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User 
> ID='';pwd='';Data Source=c:\mydb.mdb"
> ---------
> when user start the access application,  they entered their user name
> and 
> password ,i want that username and password to be  used in the above 
> connectionstring syntax, how i do this?
> waiting for u ppl reply
> 
> 
> 
> 
> 
> 
> 
> 
> > i hav make my database secured ,& my administrator user has full
> access 
> to 
> a> ll objects of database.
> O> ne of my form  has in its load event following codeing;
> b> con.Provider = "Microsoft.Jet.OLEDB.4.0"
> b> con.ConnectionString = CurrentDb.Name
> b> con.Open
> w> hen i open that form i got following error
> 
> > You do not have necessary permissions to use 'c:\mydb.mdb' object.have
> 
> ur 
> s> ystem administrator or the person who created this object establish
> the 
> a> ppropriate permissions for you
> 
> > 
> n> ow tell me wat's the wrong
> 
> > waiting for ur uregent reply
> 

> Hi!

Isn't that you have to indicate it in the connection string, that's to 
say, 
supposing your user is

User id = JerryW
Passwd  = foobar

con.ConnectionString = ".....;User ID=JerryW;pwd=foobar;Data Source=...."

That should work (I do not remeber if quotes must be there or not)...

HTH

   Claudio de Biasio
     Team 97 S.r.l.


Quoting Hanan <et_man_1980@h...>:

> i hav used the following syntax but i got error Authentication failed 
> --------
> con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User 
> ID='';pwd='';Data Source=c:\mydb.mdb"
> ---------
> when user start the access application,  they entered their user name
> and 
> password ,i want that username and password to be  used in the above 
> connectionstring syntax, how i do this?
> waiting for u ppl reply
> 
> 
> 
> 
> 
> 
> 
> 
> > i hav make my database secured ,& my administrator user has full
> access 
> to 
> a> ll objects of database.
> O> ne of my form  has in its load event following codeing;
> b> con.Provider = "Microsoft.Jet.OLEDB.4.0"
> b> con.ConnectionString = CurrentDb.Name
> b> con.Open
> w> hen i open that form i got following error
> 
> > You do not have necessary permissions to use 'c:\mydb.mdb' object.have
> 
> ur 
> s> ystem administrator or the person who created this object establish
> the 
> a> ppropriate permissions for you
> 
> > 
> n> ow tell me wat's the wrong
> 
> > waiting for ur uregent reply
> 
that prob solved
thanx all for ur cooperation