Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

interfacing with Access DB on Server

Posted on 2004-04-01
3
Medium Priority
?
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
Sleepyhead_NO earned 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

670 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