VB6 Connect to remote Access DB on server
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.
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.
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
learn to develop Client/Server apps
Access is a Desktop database.
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.
Last edited by Phil Weber; 11-25-2005 at 01:08 AM.
Reason: Deleted advertising
By Mark in forum Database
Last Post: 07-15-2002, 11:24 AM
By Faucon Blanc in forum VB Classic
Last Post: 05-01-2002, 10:28 AM
By Peter Mount in forum VB Classic
Last Post: 10-12-2001, 04:42 PM
By David Jones in forum Database
Last Post: 08-31-2001, 01:22 PM
By Mak Foka in forum authorevents.kurata
Last Post: 04-18-2000, 09:21 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL