I have a list of an unknown number of Microsoft Access 2003 databases. All of my databases have the same tables but obviously different recordset data.
I am able to open one table from one of the databases (select a table from one database) and edit one recordset. Is there any possible way to update this change to all databases?
For example, if I open Database A and Table AA and edit a recordset called "Speed" from 1 to 2, can I change all values of "Speed" in every database under the same Table and recordset?
Sorry this is a bit confusing. I have been trying to figure this out for a while and do not know if I need to create an unknown number of databases.