Solved

interfacing with Access DB on Server

Posted on 2004-04-01
3
154 Views
Last Modified: 2013-12-23
I currently have an Access Database on my PC.  I want to transfer it to my Server and then write a VB6 program to access and update the database.  What is the procedure I have to go through to do this
0
Comment
Question by:lynn41
3 Comments
 
LVL 3

Accepted Solution

by:
Sleepyhead_NO earned 125 total points
ID: 10797416
Access database is just a normal file so you can just copy it to the server. Will the VB program be on the client or the server? If it's on the client then you will need to access the Access database over the network as  a normal file. If you cannot do this then use SQL Server or some other database that you could connect via TCP/IP. If you have file access to the server database (either on the server or from the client over the network) you would make a VB program that will use ADO to access the database). Just do a google or buy a book and you will find much information on how to make a VB program and use an Access database.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now