Pascal,

In the DE's .BeforeOpenTables put the following for each table and/or view:

THIS.Cursor1.Database='f:\MyAPP\data\myDatabase.DBC'
THIS.Cursor2.Database='f:\MyAPP\data\myDatabase.DBC'
etc.

HTH
Barbara

>Hello all,
>
>I have an application that was developped a few years back for
>a client to be used at one of their sites. They now want to use it
>for multiple logical sites (but one physical location). I figured the easy way to do this would be to just create multiple sets of data by creating duplicate of the database and letting them select the one they want to work with at the start of the application.
>
>The problem I encountered is this: it seems that when you use the data environment of a form to open tables it remember to which database these tables were linked to (the physical location). My second set of data has the same database name as the first (nmi.dbc) and I open that second one at the start of the application with an open database statement. I was hoping my forms would still work with that new database since its the one currently opened.
>
>Anybody has a solution/suggestion for me?
>
>(apart from manually opening the tables instead of using the DE)
>
>Thanks in advance,
>Pascal Charbonneau
>Visual Programming