Home > Visual Basic Language > MS access permission problem

MS access permission problem

Hi all,

 My application using Ms Access DB. when i connect to DBfrom client machine 

it show error at conn.open. the error was "you need permission to view its data".

If I login to the server, it works perfectly.



    The connection string was "provider=microsoft.jet.oledb.4.0;Jet OLEDB:Database

Password=pwd;data source=\\" & SerIP & "\NTDB\Config.mdb"

(server IP - SerIP, NTDB - shared folder in server)



 

      Is there any way to access the DB from code without server login? pls guide me

Changed TypeMartin Xie - MSFTMSFT, ModeratorTuesday, November 24, 2009 8:24 AMChange to Comment due to no follow-up.

JackDK Wednesday, November 18, 2009 7:01 AM

Try this connection string

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" & SerIP & "\NTDB\Config.mdb" & ";User ID=Admin;Password=Password"

Replace Admin with Database user name
Replace Password with Database user's password.

If you get some exception please post it here.

Thanks, A.m.a.L Dot Net Goodies
Don't hate the hacker, hate the code

A.m.a.L - aditi.com - Think Product Wednesday, November 18, 2009 7:35 AM

We are changing the issue type to “General Discussion�?because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�?by clicking "Change Type" at the top of the thread. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Martin Xie - MSFT Tuesday, November 24, 2009 8:25 AM

Hi all,


 My application using Ms Access DB. when i connect to DBfrom client machine 


it show error at conn.open. the error was "you need permission to view its data".


If I login to the server, it works perfectly.





    The connection string was "provider=microsoft.jet.oledb.4.0;Jet OLEDB:Database


Password=pwd;data source=\\" & SerIP & "\NTDB\Config.mdb"


(server IP - SerIP, NTDB - shared folder in server)





 


      Is there any way to access the DB from code without server login? pls guide me

What Access are you using? 2007?

Don't judge me, just Upgrade me. Thanks!

Malange Tuesday, November 24, 2009 10:58 PM

sorry for delayed reply. am using MS Access 2003.

JackDK Wednesday, November 25, 2009 1:31 PM