[mso] Re: Access :VSMail mx4
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Wed, 14 Jul 2004 13:23:29 -0700
Glenda,
Ideally, having a View to link to would speed your updates on the backend.
When you split the database into front-end back-end there are a few very
important considerations. One is to make sure the fields you query on
frequently are Indexed (yes, even if they are not the primary field). This
will improve the efficiency of your queries, especially when running across
the network. Another is to account for periodically compacting the backend.
Since you are doing make table queries, this is VERY important. (If the
fields do not change, you may want to consider using a combination of Delete
query and an Append query.)
James
-----Original Message-----
From: Glenda Wells [mailto:gwells@xxxxxxxxxxx]
Sent: Wednesday, July 14, 2004 1:07 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access :VSMail mx4
I've seen discussion on this list regarding front/back but never gave it
much thought. When you mentioned it was like a revelation...maybe it's
been tickling the back of my consciousness for a while now but it seems
so simple I should have thought of it before.
I have a HUGE db I made a couple of years ago that I'm constantly
copying from for new DBs to share. If I work it out, I should be able
to share the front which will pull against this monster and so solve
NUMEROUS problems. What a concept, eh? I pretty much have things
running as fast as possible as far as pulling from my ODBC tables but
one thing I've been tossing around in my head is having a VIEW built by
our programmers to provide the base information then link whatever other
pieces may be needed from time to time to that. If I do a front/back,
it will probably run like lightening and I'll be a hero...hmmm...pay
raise?...evaluations are coming up pretty soon... ... ...
-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]
Sent: Wednesday, July 14, 2004 03:57 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access :VSMail mx1
Glenda,
This is a typical Front-end/Back-end setup. All your data files are in
the back end and a Front-end is distributed that contains your forms,
queries, reports and the like. Make sure each user gets their own copy
of the front-end though. If you need help with this feel free to ask.
James
_____ =20
<< ella for Spam Control >> has removed 11435 Spam messages and set
aside 0 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com=09
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
- » [mso] Re: Access :VSMail mx4
