Navigation

Can two databases co-exist in the same folder as long as they have
different connection name? I'm using frontpage 2000 and it also tells me
that it recommended to be put in one specific folder. Any problems I need
to worry about?
T.L.

I assume you are talking about Access databases.
Yes, they can happily co-exist in the same folder.
When you open a connection you need to specify a connection string. The
connection string contains the necessary information to connect to the
correct Access .mdb file. If you want to connect to both simultaneously
you'll need two connection objects. When you open each connection object you
provide the necessary connection details for the database you want to
connect to.
Whether this causes problems for the various wizards that Frontpage uses I
don't know...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "TL Jackson" <actionjackson@a...>
Subject: [asp_databases] Two Databases in one folder....
: Can two databases co-exist in the same folder as long as they have
: different connection name? I'm using frontpage 2000 and it also tells me
: that it recommended to be put in one specific folder. Any problems I need
: to worry about?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ken,
Yes, you assumed right. Sorry I forgot to say Access
databases. Thank you for the information.
T.L.
At 07:01 PM 12/22/2001 +1100, you wrote:
>I assume you are talking about Access databases.
>Yes, they can happily co-exist in the same folder.
>
>When you open a connection you need to specify a connection string. The
>connection string contains the necessary information to connect to the
>correct Access .mdb file. If you want to connect to both simultaneously
>you'll need two connection objects. When you open each connection object you
>provide the necessary connection details for the database you want to
>connect to.
>
>Whether this causes problems for the various wizards that Frontpage uses I
>don't know...
>
>Cheers
>Ken