Checking Version and Copy New Version of ADP 
Author Message
 Checking Version and Copy New Version of ADP

I would like to implement version checking in my database.  The way I was
thinking is this.

In the main form, I have a text box that has the version number of the ADP
(Say the Box Says 1.2).  I have a table called version and in it there is
one field and it says 1.3

That would mean that the databse should be on version 1.3 but the ADP File I
am using is 1.2 - therefore requiring an update  (I would check this on the
open event of the first form and do the comparison).

My question is this....  How would I then copy the file from a sharepoint on
my server (Call it \\server\data\distro) to my local and have the ADP close
and re-open with the new version?  Or is there a Reload function that it
will re-load it self ?

Thanks,
Shawn



Tue, 07 Jun 2005 22:47:31 GMT
 Checking Version and Copy New Version of ADP

Hi,

what i once did with an mdb-file (but i see no reason, why it shouldnt work
with adp as well) was:

The customer doesnt open the adp-file directly but he starts an ordinary
Batch-file, which - before starting Access - copies the Front-End from the
server to the client and THEN starting Access always with a fresh and always
up-to-date Front-End

No need of checking versions or so, and - at the end - the customer was
extremely happy because there was not any longer any hassle with compacting or
with corrupted front-end files etc.

--
mfg

Klaus Oberdalhoff [MVP]

Quote:

> I would like to implement version checking in my database.  The way I
> was thinking is this.

> In the main form, I have a text box that has the version number of
> the ADP (Say the Box Says 1.2).  I have a table called version and in
> it there is one field and it says 1.3

> That would mean that the databse should be on version 1.3 but the ADP
> File I am using is 1.2 - therefore requiring an update  (I would
> check this on the open event of the first form and do the comparison).

> My question is this....  How would I then copy the file from a
> sharepoint on my server (Call it \\server\data\distro) to my local
> and have the ADP close and re-open with the new version?  Or is there
> a Reload function that it will re-load it self ?

> Thanks,
> Shawn



Thu, 09 Jun 2005 02:33:05 GMT
 Checking Version and Copy New Version of ADP
Hi Klaus,

That would work fine for the internal network cause it is nice and fast
although for the people connecting over VPN the would have to download it
everytime and therefore it wouldn't be worth it.

In addition, I was thinking about putting in that extra little bit of code
to determine whether it was a larger upgrade 1.X or a smaller upgrade that
is not necessary 1.2X.

Thanks,
Shawn


Quote:
> Hi,

> what i once did with an mdb-file (but i see no reason, why it shouldnt
work
> with adp as well) was:

> The customer doesnt open the adp-file directly but he starts an ordinary
> Batch-file, which - before starting Access - copies the Front-End from the
> server to the client and THEN starting Access always with a fresh and
always
> up-to-date Front-End

> No need of checking versions or so, and - at the end - the customer was
> extremely happy because there was not any longer any hassle with
compacting or
> with corrupted front-end files etc.

> --
> mfg

> Klaus Oberdalhoff [MVP]


> > I would like to implement version checking in my database.  The way I
> > was thinking is this.

> > In the main form, I have a text box that has the version number of
> > the ADP (Say the Box Says 1.2).  I have a table called version and in
> > it there is one field and it says 1.3

> > That would mean that the databse should be on version 1.3 but the ADP
> > File I am using is 1.2 - therefore requiring an update  (I would
> > check this on the open event of the first form and do the comparison).

> > My question is this....  How would I then copy the file from a
> > sharepoint on my server (Call it \\server\data\distro) to my local
> > and have the ADP close and re-open with the new version?  Or is there
> > a Reload function that it will re-load it self ?

> > Thanks,
> > Shawn



Thu, 09 Jun 2005 13:33:19 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Standard version x Desktop version

2. compilar de version 10 a version 7

3. Restore version 7.0 DB to version 2000 instance

4. OnLine version 5 and version 6

5. To administer the version 6.5 with the Enterprise Manager of the version 7

6. US Version and National version of MS SQL Server

7. Informix ESQL versions vs. Online version

8. Do I need a new version of SE/SQL when moving to a dual processor

9. PRESS INFORMIX-ONLINE DYNAMIC SERVER VERSION 7.1 SETS NEW TPC-C PERFORMANCE RECORD

10. MS_SQL 2000 is there a end of life on it and is there a new version

11. New Version of DBA/Query Tool

12. New version of 4gltags (3.7)


 
Powered by phpBB® Forum Software