Multiple Front End Users

[SueW]

Creating a database for scheduling senior citizen transportation. The
database will reside on the network so all three can use. Two or more staff
members will need to add, edit, entries to a table throughout the day. Two
or more staff members will also need to run a report to show what has been
scheduled throughout the day at moment's notice to be sure they are not
overscheduling.

Can one or more persons work in the same table at the same time?
When entries are added or changed will all three staff members see the most
current data if the table is open?
Can the report be run by one than more person at the same time?

 

[Jeanette Cunningham]

Trying to share tables in the same database on the server for 3 different
users is one of the biggest No No's in using access.
Many posts have been written to answer this question.
Without reinventing the wheel, here is a well respected link

http://www.granite.ab.ca/access/splitapp/index.htm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jerry Whittle]

For the most part, yes IF each person has a copy of the FE on their PC.

They can be working in the same table. There might be some contention issues
if they are working on the same exact record.

Make sure that all the users have Read, Write, Create, and Delete priviliges
to both the database file on the network AND the entire folder holding it.
This will save a lot of grief. Also turn off Compact on Close.

 

[Tony Toews [MVP]]

You've already received some good suggestions on splitting your
database into a FE and BE.

Can one or more persons work in the same table at the same time?
When entries are added or changed will all three staff members see the most
current data if the table is open?

Note that if you have a continuous form showing you all the entries in
a table, for example the vehicles table, you will want to add a
command button to the top of the form doing a me.requery. This will
refresh the continuous form so new records will be displayed.
Frequently updates to current records will change in a few seconds but
this will help force those to be visible as well.

Can the report be run by one than more person at the same time?

Yes. But I'd definitely consider giving the users forms rather than
consuming paper. If those users aren't using the app then consider
giving them the app as well. There are ways of making the screens
read only for certain users.

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/

 

[Armen Stein]

You've already received some good suggestions on splitting your
database into a FE and BE.

And if you follow those suggestions, you'll want to have a good way to
manage the linked tables. You're welcome to use our free J Street
Access Relinker on our J Street Downloads page: http://ow.ly/M56Q

There's a ReadMe table with instructions.

Cheers,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[David W. Fenton]

you will want to add a
command button to the top of the form doing a me.requery. This
will refresh the continuous form so new records will be displayed.

I hate mixing terminology like that. Requery reloads the original
recordsource/rowsource, so it gets any records added (or deleted)
since the recordsource/rowsource was loaded. Refresh updates the
records that are displayed with any edits made by other users.

I would reword what you said as:

...this will reload the continuous form records to reflect any
deletions and show any newly added records.

 

[Tony Toews [MVP]]

I hate mixing terminology like that. Requery reloads the original
recordsource/rowsource, so it gets any records added (or deleted)
since the recordsource/rowsource was loaded. Refresh updates the
records that are displayed with any edits made by other users.

I would reword what you said as:

...this will reload the continuous form records to reflect any
deletions and show any newly added records.

Good point. My clients tell me that they don't understand the word
requery but refresh makes sense to them. So I tend to mix those pu.

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/

 

[Tom Wickerath]

Hi Sue,

I have an article that may be helpful for you:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[David W. Fenton]

Good point. My clients tell me that they don't understand the
word requery but refresh makes sense to them. So I tend to mix
those pu.

Well, that just STINKS.