This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EA11.505FAA78
Content-Type: text/plain;
	charset="iso-8859-1"

Hi there,

I'm trying to develop a client/server access database.
The Tables will be linked from a separate DB so there is no issue there.

The clients will have a local copy of the front end, where there will be a
master copy on the server, where all changes take place to forms, macros,
reports.

Basically I need to know how to check which version the client has, so that
if they have an old version of the front end it downloads the newer version
automatically.

Is this possible?

Thanks
Sam Rose

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EA1C.14D82CE0
Content-Type: text/plain

I don't have any sort of version checking built into the application, but I
do have an auto update for the program built into the users logon scripts(we
are on an NT 4.0 Domain here). basically, it checks the name of a file, to
see if the file exists. if it doesn't exist, it copies the latest DB
version, and the file to the system. the file itself isn't anything fancy,
just a test file, with one word. what I do is change the name each time to
the release date of the program.I have been using this method for almost a
year, and it seems to work pretty well
 
hope this helps

Thanks 

Dave 

-----Original Message-----
From: Sam Rose [mailto:Sam@d...] 
Sent: Monday, April 22, 2002 11:21 AM
To: Access
Subject: [access] Version Checking



Hi there, 

I'm trying to develop a client/server access database. 
The Tables will be linked from a separate DB so there is no issue there. 

The clients will have a local copy of the front end, where there will be a
master copy on the server, where all changes take place to forms, macros,
reports.

Basically I need to know how to check which version the client has, so that
if they have an old version of the front end it downloads the newer version
automatically.

Is this possible? 

Thanks 
Sam Rose 

--- 

Sam,

<< Basically I need to know how to check which version the client has, so 
that if they have an old version of the front end it downloads the newer 
version automatically. >>

Hmmm...good one.

* I would suggest first creating a table with one field in it called 
datVersionDate.  This table would be in everyone's database, including the 
master.  Enter the version of the most current version date there.

* Next, create a DOS batch file that copies the master version and 
overwrites each user's local copy that's sorted in a directory everyone 
has.

* When your master version is updated, change the datVersionDate entry on 
the master.

* On the switchboard (or first form that opens), enter a procedure on 
the "On Open" event that compares the master's version date to the user's 
version date.

* If the user's version is older, a message box will pop up telling the 
user to run the batch file that's located in the same directory as their 
local database.  You can either let the user continue with the old version 
or shut down the database.

I wish I could say write code to run the batch file automatically, but you 
cannot overwrite the old version while you have it open.  And if you close 
your old version first, I don't know if the VBA code to do the overwrite 
will continue or just stop cold because you closed the database.

Greg

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1EA1E.5DC14430
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

There is an article/tip complete with code in the May 2001 issue of
Access-VB-SQL Advisor that describes a technique to handle this 
problem.
If you check with Advisor.com you may be able to get the back issue.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Sam Rose [mailto:Sam@d...]
Sent: Monday, April 22, 2002 10:21 AM
To: Access
Subject: [access] Version Checking

Hi there,
I'm trying to develop a client/server access database.
The Tables will be linked from a separate DB so there is no issue 
there.
The clients will have a local copy of the front end, where there will 
be a
master copy on the server, where all changes take place to forms, 
macros,
reports.
Basically I need to know how to check which version the client has, so 
that
if they have an old version of the front end it downloads the newer 
version
automatically.
Is this possible?
Thanks
Sam Rose

I've read several books/articles with interesting solutions, most of
which worked only if you had a table in the application, which you
can't in a project.  So here is my twist on a theme.

When releasing an version of the project, I increment a version number
in a non visible label on the login/splash screen.  During login the
sql2k database has a table, that indicates the version required.  If a
newer version is required, the app shells out to a batch file and
closes.

Note: The timing of events combined with network traffic has caused
intermitant problems, resulting in having the user execute the batch
file manually.  So I'd like to eliminate this method.  FYI, I had
thought that the database connectivity might have had some play in this
traffic, so I tried reading an INI file on the server with the same
results.  I need to abort this method, which 90% of the time works
fine.  I just don't like support calls of this nature.  

The next revision of this theme is being modified so that during the
application load, the splash screen will write the app version / path
info to the registry.  From the w2k servers, based on the workstaion
inventory SMS can gather, SMS will be used for an unattended
uninstall/install of the new version to the workstation at a scheduled
down time.  The minimum version check will still be there in case a SMS
packaged failed to get delivered.

--- Sam Rose <Sam@d...  wrote:
> Hi there,
> 
> I'm trying to develop a client/server access database.
> The Tables will be linked from a separate DB so there is no issue
> there.
> 
> The clients will have a local copy of the front end, where there will
> be a
> master copy on the server, where all changes take place to forms,
> macros,
> reports.
> 
> Basically I need to know how to check which version the client has,
> so that
> if they have an old version of the front end it downloads the newer
> version
> automatically.
> 
> Is this possible?
> 
> Thanks
> Sam Rose
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/