>>>>How should I design a form which is able to access to data in different directory in even different drive?
>>>>
>>>>Currently I created a form which already had the data environment. All tables needed on this form are in the data environment. Even I reset the default to different drive, the form still tries to access the default data directory in the design environment. What I did wrong?
>>>>
>>>>Jim S
>>>
>>>I think, the best way is to reset Cursor.Database properties in DE.BeforeOpenTables event.
>>Could you specify how can I reset the cursor? Thank you.
>
>Assuming that you have App object with property Datapath, you can issue
>This.Cursor11.Database=oApp.Datapath && loop it for all DE.Cursors
>in DE.BeforeOpenTables event

It works. Thank you very much Edward.