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

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.

"John" <(E-Mail Removed)> wrote in message
news:1c83101c452fc$1feedac0$(E-Mail Removed)...
> 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