Prev: checkbox as query criteria
Next: hidding group commands in ribbon and setting password with vb
From: Citipool on 1 May 2010 10:30
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!!
From: KenSheridan via AccessMonster.com on 1 May 2010 12:13
Yes, a copy of the front end is installed on each local machine. Each copy
links to the common back end on the server. Tony Toews has a free utility
for automating the updating of users' front ends at:

http://www.autofeupdater.com/

I can't help with your second point, I'm afraid.

Ken Sheridan
Stafford, England

Citipool wrote:
>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!!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201005/1

From: Tony Toews [MVP] on 2 May 2010 15:28
Citipool <Citipool(a)discussions.microsoft.com> wrote:

>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?

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/
From: Citipool on 8 May 2010 12:46
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.

"KenSheridan via AccessMonster.com" wrote:

> Yes, a copy of the front end is installed on each local machine. Each copy
> links to the common back end on the server. Tony Toews has a free utility
> for automating the updating of users' front ends at:
>
> http://www.autofeupdater.com/
>
> I can't help with your second point, I'm afraid.
>
> Ken Sheridan
> Stafford, England
>
> Citipool wrote:
> >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!!
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/201005/1
>
> .
>
 | 
Pages: 1
Prev: checkbox as query criteria
Next: hidding group commands in ribbon and setting password with vb