-
Mar 9th, 2021, 02:38 AM
#1
Thread Starter
Fanatic Member
Connect to a remote MS Access database in vb6
Hi
I have below connection to save data on Local Computer .How to Connect to a remote MS Access database in vb6
cnn1.Provider = "Microsoft.Jet.OLEDB.4.0;"
cnn1.Properties("Jet OLEDBatabase Password") = pword
cnn1.ConnectionString = App.Path & "\Data\Sample.mdb"
cnn1.Open
Thanks
Last edited by Jagjit; Mar 9th, 2021 at 02:43 AM.
-
Mar 9th, 2021, 03:18 AM
#2
Re: Connect to a remote MS Access database in vb6
Can you explain what in this case a remote database is?
Is the MS Access file located:
1. on a network share
2. somewhere on the local network
3. a computer on the internet?
-
Mar 9th, 2021, 03:44 AM
#3
Thread Starter
Fanatic Member
Re: Connect to a remote MS Access database in vb6
Hi
Somewhere on the local network
Thanks
-
Mar 9th, 2021, 07:03 AM
#4
Re: Connect to a remote MS Access database in vb6
In that case I think I would first try a local network share.
-
Mar 9th, 2021, 09:55 AM
#5
Hyperactive Member
Re: Connect to a remote MS Access database in vb6
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|