VBA to check for latest version of front end?

[none]

I have a split database where the users have a local copy of the front
end. I would like to use VBA to check whether the users have the most
recent version. I have set up the following tables:
tVersion-Back-End (link to table in the BackEnd version)
tVersion-FrontEnd (local table in the FrontEnd version)

Each has a field Version where I am planning to put in the version
numbers.

Now, I am just starting to use VBA in my Access projects. Can someone
point me to some coding to accomplish my task above? Can someone also
point me to a good resource (book, website, course) that would take me
from a beginner/novice VBA user to a moderate user?

Thanks!!

 

[doodle]

Tony Towes has a script that checks it for you. It creates a shortcut
on the desktop and whenever the user opens from the shortcut, it
checks to see if the user has the latest version. If they don't it
copies the new version to their local machine.

no sense in recreating the wheel...

http://www.granite.ab.ca/access/autofe.htm

-a

 

[none]

Thanks. I was hoping for something a lot simpler that would just
notify the user that s/he may not have the latest version of the form/
front end.

Thanks.

 

[James A. Fortune]

Thanks. I was hoping for something a lot simpler that would just
notify the user that s/he may not have the latest version of the form/
front end.

Thanks.

I mention one way to do that here:

http://groups.google.com/group/microsoft.public.access/msg/804793b1757293f6

James A. Fortune
(e-mail address removed)

 

[Todos Menos [MSFT]]

if I were you; I would jsut use Access Data Projects

there isn't as much maintenance because queries are stored in one
place-- on the database server

it's just a much more mature environment than anything else like MDB

 

[Todos Menos [MSFT]]

and I would reccomend that you get into SQL SERVER not into Access

 

[Tony Toews [MVP]]

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Arvin Meyer [MVP]]

Logically, if the user doesn't have the latest version of the front-end, you
are going to download a new one. So it seems efficient, unless the front-end
is unusually large, or there are a lot of users, to just replace the
front-end with every new usage. That has the added advantage of always
having a fresh copy that never needs compacting, and never has any
corruption.

 

[Larry Linson]

Thanks. I was hoping for something a lot
simpler that would just notify the user that
s/he may not have the latest version of the
form/ front end.

You'll find an article on "versioning" at http://accdevel.tripod.com. It
may describe just what you are interested in doing.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

and I would reccomend that you get into SQL
SERVER not into Access

Note that this person is _still_ A a r o n K e m p f and that he is
_still_ not an employee of Microsoft.

Larry Linson
Microsoft Access MVP

 

[none]

Thanks for all of the input.

 

[David W. Fenton]

and I would reccomend that you get into SQL SERVER not into Access

And what the hell would you use for a front end, Aaron?