How to create a batch file

maya

Registered User.
Local time
Today, 10:15
Joined
Jun 11, 2003
Messages
139
Hi all, i really really need help here coz i dunno nothing abt how to create batch files...

currently i ahev a back end database in the server and a FE database in the users computer...

the prob now is how do i create a bacth file so that if any changes are to be made to the forms of table in the future, the users will be able to upgrade to this latest version thru a bacth file...hope some one could give me a detailed explanation on this...thanx a lot...ur help is really appreciated :)
 
Maya,

You could have a table that holds the latest revision date.
Your main form could use its On Open event to popup a form
that says "Latest" revision is "some date" do you wish to
load a new version.

If they select yes, you could use the Shell function to start
a .BAT file, then exit Access (DoCmd.Quit).

The .BAT file could ask for them to hit return (to give Access
time to close), copy the appropriate file, then launch the
new front end.

Primitive, but functional.

Maybe someone else will have other ideas.

Wayne
 
hmm

thanx for the explanation but i think i need more than that on how to write the batch code....and what is the best way to release the batch file whenever needed only...

i have two separate for my front end which is a mdb file which i can modify and the mde file which cant be modified...so if i do the modifications in mdb, how can i create a batch file to copy the modified forms in mdb to the front end mde file...thanx
 
maya,

You don't copy them into the .mde, you make a new one from your
.mdb file. Then you just copy it to their drive from a server.

The "old" .mde is obsolete.

Wayne
 
so i dont have to actually create a batch file for this rite?? i just modify the existing mdb...put it on the server and distribute to everyone from there and create an mde file or just leave it as mdb in each pc...am i rite??
 
ohh...yeah just create the mde again and put it on the server for distribution..

anyway the new prob im facing now is speed...i tested my database just now with the tables in the backend...and when i tried to open the forms in front end...it seems to take a very long time to load...within 10-12 seconds and sometimes access just stops responding...any way to handle this...thanx
 
thanx

thanx wayne really appreciated it...what i did was instead of using the sql statemnt as the recordsource of the form, i changed into a query and now its working fine but am nt sure how will it be when multiple users uses it...anyway thanx
 

Users who are viewing this thread

Back
Top Bottom