: : Hi,
: : I split my database. How do I update the forms, queries and reports?
: : this may come as a dumb question, but I spent so much time googling splitting the database and none how to update the forms and queries.
: : Any help is greatly appreciated.
: You could use replication but I've seen posts where its problematic.
: What I do is update a development database and save it to a folder
: on the network drive. I have a VB6 program on each workstation to
: check the app version number and start the app, if there's a version
: update it copies the new file with updated forms, reports, etc to
: the local workstation, then starts the new version.
: You could just as easily manage this in a small access db that
: resides on the network.
Could you post the VB6 code for checking the app version number, etc? I am tryign to figure out how to update an Access database if there are changes to the tables, update them with a newer version, while retainging the user's data.