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.

: 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.

: : 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.

uploaded an example in access,
see the readme file first. for your app
you'll need to revise paths, filenames, etc.
also, add error handling. you can store the
version num in a file, or the registry, but
this example uses a txt file filename

Thanks for sharing about sql server. I think it is use full for administrator
[url=http://www.american-windows.com/]Windows va[/url]
[url=http://www.american-windows.com/]Doors Fairfax[/url]