>I need some advises on a form that is used for sychronizing remote data. At first, I have a database that is opened exclusively on that form. However, some tables that will be used for sychronization are part of another database. As the process requires exclusive use for such process, I need to open the other database in exclusive mode. However, doing that will shut off the default database. I need to work with both at the same time. Any idea?
What do you mean by "shut off the default database"? You can have both open at the same time. I had an app where four databases were simultaneously open, no problem. Not sure I tried to keep them open exclusively in an exe, but surely happened within development, no problem at all. You may Set Database To at some point, i.e. you may switch from one database to another at times, if needed, but AFAIK that's pretty much all the trouble there is.