Distributing FE on split database

[John]

I'm going to split a database that is currently used by
approx 75 users. I understand that the FE needs to be on
the users hard drive. Question is: what is the best way to
distribute the FE? Do you re-distribute every time you
make changes to the FE? The size of the FE will be 5-6 MB.
Are there any tools or guidelines Microsoft provides for
distribution - or is it basically everyone build your own
process. Any thoughts would be appreciated. thanks

 

[Kevin3NF]

I use this awesome free utility:
http://www.granite.ab.ca/access/autofe.htm

Only took me an hour to set up the first time I did it...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.