exporting data to acess to access

[1967chris]

Hi guys im trying to transfer data from a data input form into 2 data bases at the same time on a button. Currently after filling the form it populates the same database but I would like to send the data that has been inputted over to another database as well . Someone told me to try" docmd.transfer database" but im fairly new to the coding side of things and I keep getting syntax errors .


Any help is much appreciated

[ItsMe]

You could link a table from the second database. Another approach may be to use code and a connection string to do batch updates to the second database.

[1967chris]

You could link a table from the second database. Another approach may be to use code and a connection string to do batch updates to the second database.

Well both sound interesting but I will have to read up on how to do both as im still fresh to this .Thanks for the speedy reply

[ItsMe]

There is a wizard to link tables. Use the External Data tab within the ribbon to launch the wizard for Access.

If someone proposed to me what you are describing, I would want to know their motivation to do so. There are not many real world scenarios that would require this. In fact, having data in multiple DB's is not desirable. The exception is when managing business critical data that requires backups, security measures, regional access, fault tolerance, etc.