import tables from another access DB

[steveb]

Hi

I am currently developing an Access database (2k), the database is being
tested off-site and when I issue updates/improvements I have to get the
other user, who is not familiar with Access, to send me his DB so I can
import his data which is in two tables into the new DB. Is there anyway I
can do this using code? Bearing I do not know the file path to the other
users DB.

Any help would be very much appreciated.

SteveB

Remove the remove to email

 

[Nikos Yannacopoulos]

Steve,

It would be much easier if you split your database into a front end and
a back end (Tools > Database Utilities > Database Splitter) with the
back end holding all the datbles and nothing but tyhem, and the front
end holding everything else. Under such a schema you would only need to
send over the front end, and your user would only have to save it over
the previous one and that's it! The only other thing you might need is
some simple code to re-connect to the back end on startup, if the other
user has his/her back end in a different folder that you have yours. Of
course, if they have it on their local HDD, you could just replicate
their abck end path and have no need for this step.

HTH,
Nikos