How to help user to import tables from old mdb to new mdb file

[mini1969]

Hai,

I have distributed an access database package for maintenence monitoring in my company. many users have been using it for awhile. Now I have come out with new version which contains advanced features.

The problem is how can I automate the process of importing the tables from the old mdb file to new mdb.The user should be able to do it (in a start up routine) with just selecting the location of the old mdb. I am sure this would be possible with VBA. Can some one help me?

 

[FancyPrairie]

I wouldn't import, I would link to the tables. Your database should be split between a front-end (contains forms, reports, modules, queries, pages) and a back-end (contains tables only). Then the Front-end should link to the tables in the back-end.

 

[VBslammer]

I concur.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[mini1969]

Thnaks Fancie and VB slammer. But for a very low level user will it not be more convenient if we provide a complete package (new) then ask gim to use the option to import if he would like to ? I was thinking of using SQL queries to get the whole data into the new one, but I expect direct method !

 

[mini1969]

thank you fancie, finally i am doing the way you suggested