can access 2003 update multiple front ends on workstations?

[Satsua Abe]

The company I work for has 12 workstations with a front-end on each unit.

I was wondering does the 2003 version allow to make updates to all units
from one master copy?

At present I must update each front-end mdb on teh client side one by one.

I just need to know if this is built in to cascade changes in objects.

Thanks

Satsua Abe

 

[Rick B]

You need to automate this. You should be maintaining a master copy on your
harddrive. The front ends could comapre a revision date in a local table to
a revision date in a linked table in the back end. This back end date would
be the latest revision available. If the two do not match, you could run a
DOS batch file to delete the local front-end and copy the master.

There are many samples out there to help you automate your front-end
updates. Do some searches.

In answer to your direct question, "no" a change to a file on your pc will
not affect the copies running on other PCs.

Rick B

 

[Lonnie]

My company currently runs several databases with a share
on the tables. I did a master copy on one computer like
above stated and it always worked good but could be slow
at times. Then we changed to SQL lite, it works a whole
lot better and it wasn't that hard to learn SQl.

 

[Brendan Reynolds]

No, but try Tony Towes 'Auto FE Updater' at the following URL ...

http://www.granite.ab.ca/access/downloadsindex.htm

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.