>>From OPEN DATABASE help: "If you open a database twice in succession without closing the database, the database retains the same settings specified with the first DATABASE OPEN command".
>>
>
>That must be what was happening in my case. Thank you for your help.

Yes, that's why you have to close database first if you want to open it with different setting.