larry linson

comp.databases.ms-access isn't a particularly good place to get VB6 code
snippets, because most of the people here will tell you that there's rarely
good reason to use a VB6 front end with an Access/Jet database, in "normal
business applications". I've used classic VB since version 1, but never for
database applications, because it is so much easier to do in Access the
database work I wanted to do.

You might search the archives of this newsgroup at http://groups.google.com,
using Advanced Group Search, or you might seek a newsgroup that deals with
general VB questions, like comp.lang.basic.visual.misc if you didn't get
response from your posting to comp.lang.basic.visual.database, or one of the
microsoft.public.vb.database newsgroups -- there's that base group, then
append .ado, .dao, .odbc, .rdo for specifics on which access method you're
using.

Are you certain that Access will be installed on the target machine? It
often is not, and certainly need not be for VB to access a Jet (often, yes,
even by Microsoft, called an Access) database. Jet 3.51 came with the
original release of VB6, and was updated to Jet 4.0 with one of the Service
Packs to VB6.

Larry Linson
Microsoft Access MVP