Hello All,
Could any of you give me some suggestions on the best way to do the following and save me loads of hours fiddling arround:
I have an Assets Database that contains linked tables contaning user details from our Helpdesk database.
I have made a blank cutdown version of the assets database to use on a laptop off line.
On the on-line version I've written a update query that can access the mdb file on the laptop when I connect it to the network and syncronise any new data.
What I need is an efficent way to copy the data from the online tables into the correct tables in the offline database by executing a macro on the on-line version.
Has anyone done this?
I have had a little play with DoCmd.TransferDatabase but it doesn't replace the tables it just creates new copies Eg: Equipment_1, Equipment_2, etc.
As always
Any help, advice, spelling corrections gratefully received!
All the best
Marc
Could any of you give me some suggestions on the best way to do the following and save me loads of hours fiddling arround:
I have an Assets Database that contains linked tables contaning user details from our Helpdesk database.
I have made a blank cutdown version of the assets database to use on a laptop off line.
On the on-line version I've written a update query that can access the mdb file on the laptop when I connect it to the network and syncronise any new data.
What I need is an efficent way to copy the data from the online tables into the correct tables in the offline database by executing a macro on the on-line version.
Has anyone done this?
I have had a little play with DoCmd.TransferDatabase but it doesn't replace the tables it just creates new copies Eg: Equipment_1, Equipment_2, etc.
As always
Any help, advice, spelling corrections gratefully received!
All the best
Marc
