Question Locked

how to access a distributed access database in visual basic 6.0?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have developed applications using visual basic 6 and MS Access as database, but I can figure out a way to distribute the applications to more than 1 user using only 1 database. Please help!

3 replies

by robaaaaaa2

Put the app. on a server share, and short-cut to it from the users desktops.
You will probably still have to run setup on local machines to install any additional references.

by james.e.moore

One approach, assumming the users all have access to the mount point is to use table links.

Place all the tables into a seperate mdb, have the reports,forms and queries in another mdb with links to the tables.

Installing a new release is just replacing the reports,forms mdb. The tables mdb is not distributed.

The only table in the report,forms mdb would be one that contains the release version #. This would enable users to determine what release they are running.

This discussion is closed to new replies.