How to make changes to forms in a split database - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

How to make changes to forms in a split database

ranravianranravian Posts: 20Member
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.


Comments

  • dokken2dokken2 Posts: 532Member
    : 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.
  • fredfrancisfredfrancis Posts: 1Member
    : : 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.
  • dokken2dokken2 Posts: 532Member
    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
  • GeorgeWalkerGeorgeWalker Posts: 1Member
    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]
Sign In or Register to comment.