473,320 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

auto updating front-end on workstations

tdw
206 100+
I was reading the thread called "Re: Split the DB, how do I deploy the "Front-end"?" and Denburt mentioned something that I've been interested in doing with my database, and that is to create a way for each users front-end to recognize when I have made a modification to the copy of the front-end on the server. I guess I'd like a way to "push" the updated version to the workstations, or a way for their copy of the FE to see that there is a newer one, and to give them an option to update their copy.

Denburt gave a brief explanation of what he does, referencing a "main menu" and stuff like that (would that be like the Switchboard?) but I would like to see more specific suggestions, coding, etc to give me something to work with. It would sure be nice to not have to go to each work station and copy/replace everyone's front end manually.

Thanks!
Feb 6 '08 #1
10 6040
Rabbit
12,516 Expert Mod 8TB
Off the top of my head, the way I would do it is to change the name of the file to include a version number. Then you could use code to check for a larger version number and then copy it if there's a more recent one.
Feb 6 '08 #2
tdw
206 100+
Off the top of my head, the way I would do it is to change the name of the file to include a version number. Then you could use code to check for a larger version number and then copy it if there's a more recent one.
Makes sense. Then is there code to close the db file and reopen the new one? For example, if I write the code to look for a newer version each time the file is opened, can code within that file relaunch the updated one?
Feb 6 '08 #3
Megalog
378 Expert 256MB
I have a system set up to where every time a user starts the FE, they are actually calling a batch file that copies the current version to their local drive, and then starts it. This way I know they're using the most current revision every day. Here's the post I did on that process:
http://www.thescripts.com/forum/thread760986.html

But, I've also employed versioning as well, with a small form that starts on load, showing them their version # and information on what has changed in that revision. This form has a simple 'ok' button on it, which just turns it invisible. There's a timer set on this form, so that every 5 minutes it checks the BE version # (stored in a versioning table), and compares this number against the front end version # (stored in a module which houses the FE constants). If I make an update, I change the version # in the new FE, and in the BE table. The hidden form on the outdated FE's will detect the new 'current' version #, and alert the user that a new version is available, set the form to visible, and then show whatever information about the new available version I want. This allows them to decide if they want to restart and gain the new version, or to keep working with the one they have. Once alerted, the form timer resets to zero, and goes hidden again, else they'll be annoyed every 5 minutes with the update notice.

The coding behind it was very simple, but if you want me to post what I did just let me know.
Feb 6 '08 #4
tdw
206 100+
I have a system set up to where every time a user starts the FE, they are actually calling a batch file that copies the current version to their local drive, and then starts it. This way I know they're using the most current revision every day. Here's the post I did on that process:
http://www.thescripts.com/forum/thread760986.html
This sounds like a good method, since it takes almost no time to copy the file over from the server to the workstation (although it takes several minutes to copy it the other direction). I have never worked with batch files, so I'll have to do some studying on that. Any recommended sites or threads for that? I'm not really a programmer, I just fake it (and learn fast) and hope that what I do works (done good so far, with help from this forum).

But, I've also employed versioning as well, with a small form that starts on load, showing them their version # and information on what has changed in that revision. This form has a simple 'ok' button on it, which just turns it invisible. There's a timer set on this form, so that every 5 minutes it checks the BE version # (stored in a versioning table), and compares this number against the front end version # (stored in a module which houses the FE constants). If I make an update, I change the version # in the new FE, and in the BE table. The hidden form on the outdated FE's will detect the new 'current' version #, and alert the user that a new version is available, set the form to visible, and then show whatever information about the new available version I want. This allows them to decide if they want to restart and gain the new version, or to keep working with the one they have. Once alerted, the form timer resets to zero, and goes hidden again, else they'll be annoyed every 5 minutes with the update notice.

The coding behind it was very simple, but if you want me to post what I did just let me know.
This option would be the best I think if I find that copying the FE file over every time someone opens the database is too annoying to the users.
I have never used timers in Access, and again would have to study that. I know ttimers have been discussed a lot in this forum, so I can search for info here. Unless a brief lesson in this thread would be very simple... or a link?

Thanks for the advice.
Feb 6 '08 #5
tdw
206 100+
I just re-read the link you gave me, and I understand the bat file now.
I think I'll try that first, and see if it's fast enough to not disturb users.
Feb 6 '08 #6
tdw
206 100+
I just re-read the link you gave me, and I understand the bat file now.
I think I'll try that first, and see if it's fast enough to not disturb users.
Ok, I've tested it out, and it's fast enough.
Is there a way to hide the msdos window that opens up showing the bat file commands being run? maybe replace it with a splash window or something?
Feb 6 '08 #7
Megalog
378 Expert 256MB
Ok, I've tested it out, and it's fast enough.
Is there a way to hide the msdos window that opens up showing the bat file commands being run? maybe replace it with a splash window or something?
I believe there's a way you can specify what prints to the screen, and what remains hidden.. but I dont think you can hide the command window itself. It's only on-screen for 2-3 seconds at the most so I never cared. Try googling it and see what you get. If you find a solution let me know =)
Feb 6 '08 #8
tdw
206 100+
I believe there's a way you can specify what prints to the screen, and what remains hidden.. but I dont think you can hide the command window itself. It's only on-screen for 2-3 seconds at the most so I never cared. Try googling it and see what you get. If you find a solution let me know =)
http://www.geekstogo.com/forum/Hide-...ws-t56092.html

Pretty simple solution I never knew about.

Next step is to figure out how to display a message or splash saying something like "checking for updates..." during those 2-3 seconds. this thing gonna be pretty when I'm done with it :-)
Feb 6 '08 #9
tdw
206 100+
Yikes.

It looks like I'm going to have to learn to use Java SE6 to do a splash screen.
But I figured out a compromise for now: I added the lines

ECHO OFF

and

ECHO CHECKING FOR REVISIONS TO THE ORDERS DATABASE PROGRAM...

to the bat file. That way all the junk it's doing doesn't show up in the command window, but the message does.
Feb 6 '08 #10
MMcCarthy
14,534 Expert Mod 8TB
Nice thread. I'd love to see a tutorial on this if either of you are interested. Seems like something a lot of Access developers would be interested in.

Mary
Feb 7 '08 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: David Shorthouse | last post by:
HI is it posible to auto populate an access database.? I have 1 table structured Index_ID. - Index & auto number First_Name - Char50 Surname - Char50 Initals - Char50 Postcode - Char50...
5
by: Robert Downes | last post by:
I'm using the following in a page that I'm testing in Mozilla: p.actionLinkBlock {border: 1px #000000 dashed; padding: 0.2cm; width: auto} But the dashed border is extending to the right-edge...
11
by: UJ | last post by:
Has anybody had any experience writing an auto update program that will check the internet to see if there is a newer version of the code out there and download it? It doesn't seem that...
6
by: Corepaul | last post by:
I am new to Access 2000. My operating system is Windows 2000. In the early stage of development I noticed something weird. On my form, I have a Command Button named "btnAlbumUp". The first time...
4
by: MUSTAFA IRSHAD | last post by:
DEAR SIRS, I AM DEVELOPING A SOFTWARE BY USING VB.NET AND SQLSERVER 2000 FOR A NETWORK ENVIRONMENT. I HAVE A BROBLEM THAT I HAVE A FIELD FOR PRIMERY KEY WHICH IS AUTO GENERATED. I NEED THAT WHEN...
13
by: Matik | last post by:
Hello everybody, First: SQL Server 2000 sp3a, HP cluster server, MS 2003 server, database recovery model simple Torn page detection: When I have this option turned on, processes conected with...
0
chumlyumly
by: chumlyumly | last post by:
Hello scripters - OS: Mac OSX Language: PHP w/ MySQL database I've created an insert page where a user inputs his info, which then goes to four different tables in a MySQL database. The...
6
by: Jeff | last post by:
Updating my bag of tricks again. What's the level of support for margin: auto. Is this widely supported now amongst almost all browsers? It's a common request to have a "centered" page. I...
3
by: =?Utf-8?B?Um9nZXIgVHJhbmNoZXo=?= | last post by:
The problem I'm coming across now is that I can't update such a column, because I have set the auto generated value to true, and LINQ won't let me change such a value, a la...
0
by: Mogrin | last post by:
So I have this windows .net form app, and I have the following goals: -Needs to be 1 single file, the executable, in any directory the user decides to download it to. No installation folder, no...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.