Distributing FE after splitting?

  • Thread starter Thread starter Citipool
  • Start date Start date
C

Citipool

I have split my database into FE and BE using Access 2007 (OS=XP). Now I
have two questions:
1. How do I distribute FE to users workstations? There seems to be enough
information about how to split a data and secure it but not the actual steps
of how to get that FE to the user workstation. Am I just copying the FE file
and saving it on thier local workstation? Because If I create a shortcut to
that FE location on the server, then that deveat the purpose of splitting it
in the first place. I am really confused...I would appreciate it if someone
shed some lights on that part.

2. When I tried to save my FE as ACCDE I got an error message as if my
database have 2048 tables when it doesn't! So I don't understand why I can't
get it to save as ACCDE! any help?

Confused!!
 
Citipool said:
2. When I tried to save my FE as ACCDE I got an error message as if my
database have 2048 tables when it doesn't! So I don't understand why I can't
get it to save as ACCDE! any help?
Click to expand...

That's a misleading message. You probably have some VBA code that
doesn't compile due to a syntax error. Go into the VBA code and
under Tools or Debug, I forget which, click on the compile button and
fix the errors.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Thanks Ken. That's a great tool, Tony!

As for my second question, I was able to save it as ACCDE. I forgot to
compile DB. Once I did that, I was then able to save it as ACCDE.
 
Back
Top