473,545 Members | 2,058 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

2 New Member
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.Connecti onString = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\\192.16 8.1.20\SharedFo lder\Data.mdb;P ersist 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\Netwo rk\DistantPC\Sh aredFolder" 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\D ata.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 1367
twinnyfo
3,653 Recognized Expert Moderator Specialist
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

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

Similar topics

2
300
by: Brent | last post by:
Sorry if this is completely newbie, I haven't used Access in a while as my database. When I do this it works fine, OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=C:\db2.mdb"); But if I move the same access file to my network drive, it gives me an invalid path error.
10
1691
by: ej1008 | last post by:
HI all I am having a windows Control running on ASP.Net webform. From this windows control I am trying to connect to database to do some database operations. Now I am facing problem while connecting to Database from client systems which is having only .net framework without SQL Client Installed. It works fine on client systems having .Net...
4
5898
by: Scott Nicholson | last post by:
I've got a site set up that uses a network share as it's home directory. Simple stuff is working fine. When I try to put a database in there, though, I run into problems. I'm using: dim dbconn,sql,dbcomm dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & server.mappath("test.mdb") & ";")
1
1035
by: J-T | last post by:
How can I prevent my page for connecting to database when user hits the back button or refreshes the page? Thanks
1
1805
by: Tarek | last post by:
Dear all. i have a website that is ASPand it contains a database .MDB i cant change the name of the database. What is the best way i can do to preven anybody to download this database. Pls Help
1
3968
by: tian | last post by:
Hi could someone hel me with this dillema. In my current network setup, a certain Access Database(.mdb) File must be opened by two different people at the same time. At this moment in time if one person opens the specific file, another person can't open the same time, because Access Locks the file in use. How can I prevent Access from doing...
11
5216
by: menmysql | last post by:
i am getting the following error while connecting mysql database using jsp java.sql.SQLException: Communication link failure: Bad handshake can any one tell what is the actual problem
1
1972
by: yawesome | last post by:
I am using Microsoft.VisualBasic.Devices.Network to download a file from a server to a PC and am receiving a 404 error. The file is in teh download location but it has 0kb. Does anyone have any idea why it's bombing? oNet.DownloadFile(URL, FIRMWAREPATH & "\update\update.tt", "name", "pwd", True, 1000, True)
0
1080
by: rahul2310 | last post by:
how many users can share access 2010 database on Network Folder If operating system is microsoft Windows XP Or Windows 7
0
7405
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7659
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7811
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7428
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7760
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5334
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4949
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3444
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1887
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.