473,325 Members | 2,608 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,325 software developers and data experts.

Remote DataBase Connection

4
Hi All,

I have created a VB application and installed it on diffrent machines. It uses MS-ACCESS in backend. Is it possible that I store my database in one computer and all instances of my application installed on various computers (connected through LAN ) can access the single MS-ACCESS Database on my computer.

Please Help.

Regards..
Suraj
Jan 8 '07 #1
3 2937
hariharanmca
1,977 1GB
Hi All,

I have created a VB application and installed it on diffrent machines. It uses MS-ACCESS in backend. Is it possible that I store my database in one computer and all instances of my application installed on various computers (connected through LAN ) can access the single MS-ACCESS Database on my computer.

Please Help.

Regards..
Suraj

Yes you can Create DSN and
Use DSN connection
Jan 8 '07 #2
pppp84
4
Hi hari,
Thanks for responding.

Can u please elaborate it a bit .
Please explain the connection string and it's syntax with an example.

Regards,
Suraj
Jan 9 '07 #3
hariharanmca
1,977 1GB
Hi hari,
Thanks for responding.

Can u please elaborate it a bit .
Please explain the connection string and it's syntax with an example.

Regards,
Suraj

Step 1. Open Control Panel
Step 2. Open Administrative Tools in Control panel
Step 3. Click Data Sources (ODBC) then a dialog box will Open
Setp 4. Click ADD in User DSN Tab In that Dialog Box select The data Source
Step 5 . Give Your DSN Name
Step 6. Click Select OR Create to select the MS Access DB file
Then Give OK


Database Connection String

Dim dbConn as ADODB.Connection

dbConn.Open "DSN=” & <String DSN Name> & ", “ & <String User Name> & ” , " & <String Password>

then you can use the record set as usual
Jan 9 '07 #4

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

Similar topics

5
by: kackson | last post by:
Hi. I would like to access my database outside of my company. I read many documents but they are all pertaining to accessing the database via ASP or some form of web application. Is there no...
4
by: GAVO-UK | last post by:
Hello everyone. Using Access 2003 and MSDE I just started experimenting using Access as the front end for SQL using *.adp, and would like to connect the front end to the back end remotely,...
3
by: Hrvoje Vrbanc | last post by:
Hello all! Scenario: - web server at one location (domain) with VS 2003 - SQL server at a remote location (domain) - VPN connection on port 1433 between the two domains I have no troubles...
5
by: Mitya Mitriev | last post by:
Hi I created ASP.NET 2.0 web application that uses SQL Server 2000 database and it works perfectly when website and Sql server were on local machine. Then I installed application on production...
10
by: cleo | last post by:
I am migrating from VB6/Access to Visual Basic and SQL Express. I have success writing test code on my local machine and am now setting up tests for deployment to a server. I have installed SQL...
2
by: Tor Inge Rislaa | last post by:
Database on remote server On the remote server where my ASP.NET application is located there is no SQL Server or SQL Server Express. When I test my application locally it works fine because...
4
by: Noy B | last post by:
Hi, I have developed a small application that is using a MSAccess DB. the problem is that it was developed on a machine where the application and the DB are both located. now it needs to be...
8
by: BD | last post by:
I am developing C# win form app to work with remote database on SQL Server 2005. Problem scenario is as follows: 1. a form is open that has downloaded dataset to local cache 2. computer is...
3
by: Me LK | last post by:
I did a search but could not find an aswer that worked so here it goes. I just did an upgrade from 2003 to vs 2005 express. I am using a remote sql server 2000. I specifically upgrade to make...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
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...
1
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: 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
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.