How are you opening the second connection to the database? I don't use ODBC much at all but a straight connection to the DB does not, as far as I am aware, allow 2 concurrent connections EXCEPT, as from V9, if the 'database' is a csv file (or files for that case!)
The other question of course is - why do you need to open two instances of the database? Is it some form of external lookup requirement?
Hi Grant -- Thanks for answering. I wasn't really clear. I open the database, work with it, then close it, maybe open a different database, work with it, etc. If I go back later in the day and open the original database, more rows show up in Monarch than were there earlier or are there in reality. (I can view the database in SQL). It just sounds to me like a cache problem, but I didn't know if Monarch has a mechanism for emptying it. Thanks again for any help.