By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,315 Members | 1,611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,315 IT Pros & Developers. It's quick & easy.

multiple viewers in an access database

P: n/a
Ren
I have set up an access database with a switchboard to multiple forms,
reports, etc. I have gotten comflicting information about whether or
not staff throughout my facility will be able to view the information
simultaneously. I have been told if it is set up properly it will be
possible, but I am wondering how to set it up so this is possible. I
am sure others have donethis already, care to share?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes they can. You don't describe you system, but I assume you have a network
of workstation computers and one or more servers?

The standard Access application architecture is this:

1. Split the database file into 2. One is the Front End
(myApplicationFE.mdb) and contains all the forms, reports, code modules etc.
The other file is the Back End (myApplicationBE.mdb) and contains nothing
but data tables. The Front End contains links to the tables in the back end.

2. Put a copy of the front end on every user's workstation who you want to
use the database.

3. Put the Back End on the server.

So now every use will be accessing the same data, but using their own front
end.

That's it briefly. There's a wizard to help you. Tools/Database
Utilities/Database Splitter.

HTH, Mike MacSween

"Ren" <pr********@hotmail.com> wrote in message
news:49*************************@posting.google.co m...
I have set up an access database with a switchboard to multiple forms,
reports, etc. I have gotten comflicting information about whether or
not staff throughout my facility will be able to view the information
simultaneously. I have been told if it is set up properly it will be
possible, but I am wondering how to set it up so this is possible. I
am sure others have donethis already, care to share?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.