[mso] Re: FW: access-Pam
- From: Glenda Wells <gwells@xxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 5 Dec 2002 14:29:47 -0500
I'm doing this. It's logical. I've experienced the corruption thing and
the Exclusive thing. THANK YOU!
-----Original Message-----
From: James LaBorde [mailto:jlaborde@xxxxxxxxx]
Sent: Thursday, December 05, 2002 1:02 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: FW: access-Pam
Linda (and everyone one else interested),
A front-end/back-end set up is pretty much what it sounds like. You have
all of your tables containing all of your data in one database that is
stored somewhere accessible by everyone. This is your "back-end" database.
It is simply a repository for all of your data. The "front-end" is a
separate database that contains all of the forms, queries, reports and code
to run the database. It is linked to the back-end tables. This "front-end"
is then copied to any workstation that will use it. This set up allows
multiple users to have access to the same data, without having to have them
share the same database. It reduces corruption (oops, the file won't open
any more!) and contention (Hey, I can't open this, it says Joe has exclusive
control!) in the database.
To set it up. Split your database you have created. Create a new database
and move all of your tables to it (This is your back-end). Next, create
another new database and move all of your queries, forms, reports,
macros(shudder), and modules to the new database (This is your front-end).
Now open your front-end database and click File, Get External Data, Link
Tables. Then navigate to where you have stored your back-end and link all
the necessary tables. You are now ready to go.
James La Borde
South Western Federal Credit Union
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, December 05, 2002 9:31 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: FW: access-Pam :VSMail MX3
Hey you Access whizzes....would one of you like to give a short explanation
of this back end/front end database stuff....how it works and how you set it
up?
I, for one, would love to understand this better.
Thanks.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop http://personal-computer-tutor.com
FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of James LaBorde
Sent: Thursday, December 05, 2002 11:41 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: FW: access-Pam
Pam,
Will you have more than one user in the database at any time? The first
thing I would suggest is that you separate your database into a front-end
with all of your queries, forms, reports and code and a back-end that holds
just the data.
*************************************************************
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?Subject=unsubscribe
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?Subject=unsubscribe
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?Subject=unsubscribe
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:
