469,643 Members | 1,280 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

How do I...Connecting to a Microsoft JET 4.0 database (.mdb) over a LAN network

I'm building a vb6 application and I need to run it on a LAN network on Windows XP or newer. So far, I've made an algorithm to make and manage databases (Microsoft JET 4.0 databases .mdb) and I can normally use them while on a network using this connection string:

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.1.20\SharedFolder\Data.mdb;Persis t Security Info=False"

But I need to access a database from my application that's for example in a shared folder on another PC over LAN network. And I know that if I try to open a shared folder on Win7 "Computer\Network\DistantPC\SharedFolder" it pops up a window that says "Username" and "Password". So it has password protection which I need to resolve too.

Probably all I need is a good, unique connection string that can access a database like "\\192.168.1.20\SharedFolder\Data.mdb" without throwing an exception about permission. I can access it like this, but only when I disable passworded sharing on that host PC.

Please help... Thanks !
Nov 25 '14 #1
1 1151
twinnyfo
3,653 Expert Mod 2GB
behe1989,

I believe when it asks for a username/password that is to access the user's PC (and not the database). Unless the DB also has a password. From a security standpoint, I would never want to access an application residing on another user's PC. You should always place it in a shared network location. You can manage user access to the DB via folder permissions, and passwords to the DB, not to mention Custom User Menus for the DB (if it has a compiled Front End). That may be more on the MS Access VBA side than the pure VB side, but may apply to your situation.

Hope this provided a little bit of information and help.
Nov 26 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Scott Nicholson | last post: by
1 post views Thread by J-T | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.