dao connection two multiple copies of the same database

I am currently developing software that will be running in two
instances (both instances will access only one database, and therefore
two connections will need to be made to one database - one for each
instance).

I'm currently using dao, but I seem to only be able to connect once.
Once firing up my second instance I get the runtime error 3045. Could
not use database. File is in use.

Is there a way I can accomplish this. It does not need to be with
dao. I just need a way to connect to one database several times
without errors producing.

Thanks in advance
Julie Barnet

Julie, it sounds like your are opening the database in Exclusive mode.
DAO is more than happy to have multiple connections from different
applications when in shared mode. DAO defaults to shared, but the second
parameter of the open database method allows you to set it.

Matt

"Julie Barnet" <barnetj.RemoveThis@pr.fraserpapers.com> wrote in message
news:438e1811.0311111227.22edbcc5@posting.google.com...
 > I am currently developing software that will be running in two
 > instances (both instances will access only one database, and therefore
 > two connections will need to be made to one database - one for each
 > instance).
 >
 > I'm currently using dao, but I seem to only be able to connect once.
 > Once firing up my second instance I get the runtime error 3045. Could
 > not use database. File is in use.
 >
 > Is there a way I can accomplish this. It does not need to be with
 > dao. I just need a way to connect to one database several times
 > without errors producing.
 >
 > Thanks in advance
 > Julie Barnet<!-- ~MESSAGE_AFTER~ -->