A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms w/ multiple users



 
 
Thread Tools Display Modes
  #11  
Old May 2nd, 2005, 04:39 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

Good luck, let me know how it turns out. One other thing, check to see how
your default record locking is set up. From the menu bar, Tools-Options,
select the "Advanced" tab. Under "Default Open Mode" select "Shared" and
under "Default Record Locking" select "No Locks".

"Katie" wrote:

You are correct. I really wasn't understanding how it worked. Thank you for
helping me understand it better. I'm going to try it out this afternoon and
see if I can get it to work.

Thanks
Katie

"Klatuu" wrote:

Katie,

I am thinking you don't quite undestand the FE/BE model. If (as it should
be) all the data is in the BE, then everyone using the FE will see all data
entered in the BE. As to your using the BE for reports, that is incorrect.
The correct implementation is only tables (data) should be in the BE. No
queries, no forms, no reports, no nothing. Everything else should be in the
FE.

"Katie" wrote:

Ok. Here is a question - Basically there are 3 computer involved.
One computer is used by multiple people over three shifts to enter in data.
The other is used by a person who goes in after them to enter in more
information. I need the 2nd person to see the data the first group entered.
Will that happen if there multiple FE databases. The third is my computer
and I never enter data just run reports and I can use the BE for that.

"Klatuu" wrote:

Each user should have their own FE on their desktop. It creates multiple
problems and slows response when multiple users are sharing a FE on a shared
drive. I would recommend putting the FE on everyone's desktop, then seeing
if the problem still exists.

"Katie" wrote:

Well they don't have their own FE. The copy of FE is on the shared drive and
everyone uses the same one. That may be where my problem comes from. I just
have one person that has to go back and add information to what the previous
users put in. She I have her use the BE so she can access their information?

"Albert D. Kallal" wrote:

Hum....

Ok, so, each user has a copy of the FE installed on each pc..right?

You might want to check the settings for the actual form used..as each form
also can have settings for locking data...

Check the data tab of that form in desing mode and see what the record locks
setting is

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal



  #12  
Old May 4th, 2005, 07:50 PM
Katie
external usenet poster
 
Posts: n/a
Default

Ok I finally got it working. I kept trying to "copy" the database and it
wouldn't work. I had to set them up from scratch and link them.

Thanks again.

"Klatuu" wrote:

Good luck, let me know how it turns out. One other thing, check to see how
your default record locking is set up. From the menu bar, Tools-Options,
select the "Advanced" tab. Under "Default Open Mode" select "Shared" and
under "Default Record Locking" select "No Locks".

"Katie" wrote:

You are correct. I really wasn't understanding how it worked. Thank you for
helping me understand it better. I'm going to try it out this afternoon and
see if I can get it to work.

Thanks
Katie

"Klatuu" wrote:

Katie,

I am thinking you don't quite undestand the FE/BE model. If (as it should
be) all the data is in the BE, then everyone using the FE will see all data
entered in the BE. As to your using the BE for reports, that is incorrect.
The correct implementation is only tables (data) should be in the BE. No
queries, no forms, no reports, no nothing. Everything else should be in the
FE.

"Katie" wrote:

Ok. Here is a question - Basically there are 3 computer involved.
One computer is used by multiple people over three shifts to enter in data.
The other is used by a person who goes in after them to enter in more
information. I need the 2nd person to see the data the first group entered.
Will that happen if there multiple FE databases. The third is my computer
and I never enter data just run reports and I can use the BE for that.

"Klatuu" wrote:

Each user should have their own FE on their desktop. It creates multiple
problems and slows response when multiple users are sharing a FE on a shared
drive. I would recommend putting the FE on everyone's desktop, then seeing
if the problem still exists.

"Katie" wrote:

Well they don't have their own FE. The copy of FE is on the shared drive and
everyone uses the same one. That may be where my problem comes from. I just
have one person that has to go back and add information to what the previous
users put in. She I have her use the BE so she can access their information?

"Albert D. Kallal" wrote:

Hum....

Ok, so, each user has a copy of the FE installed on each pc..right?

You might want to check the settings for the actual form used..as each form
also can have settings for locking data...

Check the data tab of that form in desing mode and see what the record locks
setting is

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal



  #13  
Old May 5th, 2005, 02:10 PM
Katie
external usenet poster
 
Posts: n/a
Default

It's not working. I made sure the setups below were in place (shared and no
locks) Yesterday when I set up the databases on the other computers it
worked fine. When one user has the Form pulled up on one machine the other
user gets message record set is not updatable so she can update the records.

"Klatuu" wrote:

Good luck, let me know how it turns out. One other thing, check to see how
your default record locking is set up. From the menu bar, Tools-Options,
select the "Advanced" tab. Under "Default Open Mode" select "Shared" and
under "Default Record Locking" select "No Locks".

"Katie" wrote:

You are correct. I really wasn't understanding how it worked. Thank you for
helping me understand it better. I'm going to try it out this afternoon and
see if I can get it to work.

Thanks
Katie

"Klatuu" wrote:

Katie,

I am thinking you don't quite undestand the FE/BE model. If (as it should
be) all the data is in the BE, then everyone using the FE will see all data
entered in the BE. As to your using the BE for reports, that is incorrect.
The correct implementation is only tables (data) should be in the BE. No
queries, no forms, no reports, no nothing. Everything else should be in the
FE.

"Katie" wrote:

Ok. Here is a question - Basically there are 3 computer involved.
One computer is used by multiple people over three shifts to enter in data.
The other is used by a person who goes in after them to enter in more
information. I need the 2nd person to see the data the first group entered.
Will that happen if there multiple FE databases. The third is my computer
and I never enter data just run reports and I can use the BE for that.

"Klatuu" wrote:

Each user should have their own FE on their desktop. It creates multiple
problems and slows response when multiple users are sharing a FE on a shared
drive. I would recommend putting the FE on everyone's desktop, then seeing
if the problem still exists.

"Katie" wrote:

Well they don't have their own FE. The copy of FE is on the shared drive and
everyone uses the same one. That may be where my problem comes from. I just
have one person that has to go back and add information to what the previous
users put in. She I have her use the BE so she can access their information?

"Albert D. Kallal" wrote:

Hum....

Ok, so, each user has a copy of the FE installed on each pc..right?

You might want to check the settings for the actual form used..as each form
also can have settings for locking data...

Check the data tab of that form in desing mode and see what the record locks
setting is

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
setup for multiple users chevysales Setup, Installing & Configuration 1 February 9th, 2005 05:22 PM
Forms and multiple bumbering Cor van der Bliek General Discussion 1 February 1st, 2005 02:23 PM
Multiple Calendars/Contact Lists (3) when adding another user's mailbox... Confused Installation & Setup 4 May 28th, 2004 02:56 PM
Two versions again-language issue Otto Setup, Installing & Configuration 3 May 28th, 2004 04:57 AM


All times are GMT +1. The time now is 02:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.