Hi guys,
I made a tool that is currently in use by the Marketing department of the company. It consists of a local client (Access 2003) and a source database (also Access 2003). Since some changes had to be implemented and a new version of the client was created, I would like to make sure that everyone is working with the new version. Is there a way to check this? I was thinking there should be something like 'OnConnect", but this does not seem to exist.
All help would be very much appreciated! Thx.
The easy way to do this is to create a table in the client version of the MDB or MDE depending on which you're distributing, and have what version it is in it.
When you open to your first screen, you can have it check what version is the current version in the local table against a table on your backend that would also have the value of the current version. If the number is different, then they need to update there MDB or MDE file, by the process you've setup.
If you need more detail as to how to do this, please let me know, I'll be able to provide code examples on the areas that you don't know how to do?
Just ask, and I can answer.
Joe P.