Hello,
I would appreciate any help with some code or advice on how to provide future assistance with my db.
Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc.
I was thinking of a way (copy object method?) that can allow me to copy the updated object directly to the other database which will still have the same name but a different path as on a different server. My db is not split as it is a small db and would like to keep it as it is.
Ex:
Updated objects ares located in a file name Updates.acccdb (located in my C drive). The updated objects would be: frm1, qry1.
The destination database is named: mydb and is located on a different server: \\S00000\Users\mydb.accdb
Thank you
I would appreciate any help with some code or advice on how to provide future assistance with my db.
Since I have completed the database, periodically it may happen that some office may require an update or change to a query, form, etc.
I was thinking of a way (copy object method?) that can allow me to copy the updated object directly to the other database which will still have the same name but a different path as on a different server. My db is not split as it is a small db and would like to keep it as it is.
Ex:
Updated objects ares located in a file name Updates.acccdb (located in my C drive). The updated objects would be: frm1, qry1.
The destination database is named: mydb and is located on a different server: \\S00000\Users\mydb.accdb
Thank you