VB6 Connect to remote Access DB on server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: VB6 Connect to remote Access DB on server

  1. #1
    Join Date
    Nov 2005
    Posts
    1

    VB6 Connect to remote Access DB on server

    Hi,

    Can anyone tell me is it possible to connect a client side vb6 application to a server side remote MS Access database. If so can anyone point me in the direction of the required VB6 source code?


    Just a simple method of allowing my client VB 6.0 application to read and write records to my server side Access 2000 database.

    No security is required.

    Please note: Only VB6 and MS Access ... “NOT” .net or SQL.

    Thanks.

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    It's possible, but it's not a good idea. Access is not a "client/server" database, in which only SQL statements and resultsets travel over the wire. Because Access is designed to run locally, it generates a great deal of "chatter" between the database and application, which makes it poorly suited for client/server applications.

    That said, as long as the database resides on a network share, you may open it just as you would if it were on your local disk. Just use a UNC path to the database (e.g., \\servername\sharename\filename.mdb) instead of a drive letter.

    I recommend that you consider MSDE (http://www.microsoft.com/sql/msde/) or SQL Server Express (http://msdn.microsoft.com/sql/express/) instead of Access. Both are free, and are much better for client/server applications.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Oct 2004
    Location
    Bangalore, India
    Posts
    47

    learn to develop Client/Server apps

    Hi,

    Access is a Desktop database.

    Desktop Databases:

    Desktop databases perform all the database tasks at the client. For example, if an access user requets a customer, the entire index comes across the network and the search and retrieval takes place with in the client process.

    Multiuser desktop databases tend to make heavy demands on the network. Some desktop databases try to optimize the operation by opening only a portion of the database file. If multiple clients are working with the database, portions of the database file are constantly flying across the network.

    Regards
    bhar
    Last edited by Phil Weber; 11-25-2005 at 01:08 AM. Reason: Deleted advertising

Similar Threads

  1. Connect SQL Server Box to Oracle Box
    By Mark in forum Database
    Replies: 5
    Last Post: 07-15-2002, 11:24 AM
  2. How to exporte SQL Server 7 database to Access from vb6
    By Faucon Blanc in forum VB Classic
    Replies: 1
    Last Post: 05-01-2002, 10:28 AM
  3. VB6 with MSSQL Server 7 or other
    By Peter Mount in forum VB Classic
    Replies: 10
    Last Post: 10-12-2001, 04:42 PM
  4. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 01:22 PM
  5. Access 2000 automation from VB6
    By Mak Foka in forum authorevents.kurata
    Replies: 3
    Last Post: 04-18-2000, 09:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center