docmd's TransferDatabase method

[raminriahi]

In migrating and application from Access 2000 to Access 2003, i faced an issue with transfering my queries from a 2000 format to 2003 format. I had a form and vb code behind it to let user ick his personal queries from old version of app. and import it to new version. it works fine for stations utilizing office 2000 pro, but for stations with office 2003 queries loose the relationship between join tables. (That's not good at all for complicated queries!!!!! :-()
When i use the import utility in database window to import those queries, it works fine. So i noticed that keeping the relationship between join tables is issue.

Is there any programatically solution for enforcing this when using Transferdatabase VBA method ?

Sorry about long description :-(( Just wanted to be crystal clear on this.

Please help me, if you know how... i'm desperately looking forward!

Thanks in advance buddies!

 

[SkipVought]

Hi,

You might get better response to your MS Access question if you post in one of the many MS Access forums, rather than this one.

Skip,
[sub]
[red][/red]
[/sub]