one program multiple databases

[Triptaz]

can someone tell me were i can get information on how to set up a program
that wil be using multiple databases in access. the program will be in stand
alone mode at first but might go to a server. i also need to be able to have
a database created if there is no databse available. i am using vb6 and going
to use access unless there is a better database. I have heard that a sql
databse is better.is this true the databse with have about three to four
diffrent databses in it.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VHJpcHRheg==?=,

There is some syntax difficulty with your question. A single database can't
contain multiple "databases". Do you mean tables of data? Or something else?

Access is fine for standalone, or very few users in a LAN environment. For the
latter, it's usually split into a back-end (containing the data) in the shared
location and a front-end that's installed on each machine (with forms, queries,
reports and linked tables).

If many users would require access, and need to update data simultaneously, then
you'd need something like SQL Server, Oracle or Foxpro.

Programming for VB6, for Access, you can use DAO or ADO to create tables,
transfer data, etc. For SQL Server, you'd need ADO. I suggest you explore this
further in newsgroups specific to the type of database you're interested in
using (an Access, SQL and/or classic VB newsgroup; plus data.ado, perhaps).

can someone tell me were i can get information on how to set up a program
that wil be using multiple databases in access. the program will be in stand
alone mode at first but might go to a server. i also need to be able to have
a database created if there is no databse available. i am using vb6 and going
to use access unless there is a better database. I have heard that a sql
databse is better.is this true the databse with have about three to four
diffrent databses in it.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail