473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

how to access a ms access database through LAN in vb6?

55
Hi i want my program to be runned by multiple computers but only 1 computer has the database how can i do this? any reference or guide would be appreciated :P and also can this be done thru the internet? lets say the other computer is far far away how can it access the database? using VB6
Nov 15 '07 #1
7 11864
lotus18
866 512MB
Hi i want my program to be runned by multiple computers but only 1 computer has the database how can i do this? any reference or guide would be appreciated :P and also can this be done thru the internet? lets say the other computer is far far away how can it access the database? using VB6
There are so many ways on how to connect your database and runned on multiple computers.

Try to connect your database using the system dsn, file dsn, or udl : )
Nov 15 '07 #2
jaz215
55
There are so many ways on how to connect your database and runned on multiple computers.

Try to connect your database using the system dsn, file dsn, or udl : )

i'm not sure on how to connect can you give me an example? :P
Nov 15 '07 #3
lotus18
866 512MB
Hi Jaz

Open the run command then type odbcad32 then click OK. You can use System DSN or File DSN to add new data source. For udl, open the notepad then save it any filename you want with the .udl extension. Run the .udl file then add your new data source. : )
Nov 16 '07 #4
jaz215
55
Hi Jaz

Open the run command then type odbcad32 then click OK. You can use System DSN or File DSN to add new data source. For udl, open the notepad then save it any filename you want with the .udl extension. Run the .udl file then add your new data source. : )
Thanks i've already made a system dsn.. will the other computers on my network be able to view it now?

Thanks again. :)
Nov 16 '07 #5
xiro
1
@lotus18
can you make or give a tutorial link for that?
Apr 15 '09 #6
hagaai
1
Hi, In the server where you place the database file, you should share the folder with full permission then , in your application get the database path and then you can connect. You should use 2 database, one in the client another is the main database in the server, in the client you should get the database path and save it, then you access the database path to connect from server machine.

I hope this will help you.
Hari
Jan 5 '10 #7
vb5prgrmr
305 Expert 100+
You have to create an ODBC DSN on each of the client machines, not on the server machine. Another way, is to map to the server directory share from each of the clients or at least know what the UNC path is to the share on the server and then go see http://www.connectionstrings.com



Good Luck
Jan 5 '10 #8

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

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
11
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the...
64
by: John | last post by:
Hi What future does access have after the release of vs 2005/sql 2005? MS doesn't seem to have done anything major with access lately and presumably hoping that everyone migrates to vs/sql. ...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
15
by: Cheryl Langdon | last post by:
Hello everyone, This is my first attempt at getting help in this manner. Please forgive me if this is an inappropriate request. I suddenly find myself in urgent need of instruction on how to...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
34
by: Mathieu Trentesaux | last post by:
Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
11
by: Harel | last post by:
I have a report SQL which have been working for a few weeks. Its large and the target database is large. It has 59 join, and I dont think there is anything I can do about this, since the DB I use...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.