Split Database

[Guest]

Hi,

After splitting my database in the share drive. I have a front end and a
back end file. Why is my front end file so big in memory vs. my back end
database? I am trying to get users to copy and past the front end in their
desktop like and not their My Documents folder. Putting the front end of
the database in the desktop(like the recycle bin, IE, etc. basically shortcut
icons) so they don't have to look it up in each user's C drive. How can they
do that when the file is so big compared to the backend. Also, do I need to
close my switch board form before I split the database?

 

[Guest]

the short cut on the desk top is only a pointer. the size of a
file/application is not important.

don't know why your front end is bigger - but maybe due to alot of
forms...in any case be sure to compact and repair the application....

your switchboard being open is not an issue for the splitting process....

 

[Tony Toews]

E-mail report using Lotus Notes rather t

After splitting my database in the share drive. I have a front end and a
back end file. Why is my front end file so big in memory vs. my back end
database?

I think Access loads the VBA code of the entire MDB into memory but I
have no proof of that. Anyhow that doesn't submerse me.

I am trying to get users to copy and past the front end in their
desktop like and not their My Documents folder. Putting the front end of
the database in the desktop(like the recycle bin, IE, etc. basically shortcut
icons) so they don't have to look it up in each user's C drive. How can they
do that when the file is so big compared to the backend.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

Also, do I need to
close my switch board form before I split the database?

You might need to. You may also need or want to copy the switchboard
tables into the FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

the short cut on the desk top is only a pointer. the size of a
file/application is not important.

Just to be clear on this. You do want to copy the FE onto each PC.
But you can put a short cut on the desktop.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Hi Tony,

Thank you for enlightening me on the compacting data. How do I create a
short cut in user's PC. Can it be a short cut that is downloaded? I've seen
database created by powerbuilder where you can down load a short cut into
your display screen, so can access do that for the front end? It would save
me a lot of time for every user. Thank you so much for all your help.