BE attaches to VERSION # FE only

[lmv]

Is there any code around that would require the BE to ck the version table of
the FE before opening?

I am trying to avoid old FE's with outdated forms etc being able to link to
the BE and thought possibly having some sort of version check be the
qualifier. If it is the wrong version BE won't open with FE.

Is that possible?

Thanks!

 

[Tony Toews [MVP]]

Is there any code around that would require the BE to ck the version table of
the FE before opening?

I am trying to avoid old FE's with outdated forms etc being able to link to
the BE and thought possibly having some sort of version check be the
qualifier. If it is the wrong version BE won't open with FE.

Sure, but insert that code in the FE. Check a version number you have
specified in the FE against a field in a table in the BE. If too old
shut the FE down.

BTW I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[lmv]

Thanks Tony,
I have read many of your answers and you have been a wealth of knowledge.
And I know about your updater... but we don't have a server. We are all
running BE replica's and FE.mde so I have to give each person the new FE when
it is time.

Do you have some code you can give me to accomplish that check to the
tblversion
from the FE and if you wouldn't mind telling me how to execute it. Are you
saying I put a tblVERSION in the FE that checks the tblVersion I already have
in the BE? Sorry I have no clue on how to do this and can't remember reading
about something similar I can copy.

I certainly appreciate all your hard work and time answering questions.

Thanks again
lmv