472,127 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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=\\\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 "\\\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 1293
3,653 Expert Mod 2GB

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.