 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / July 2005FE/BE setup not working as it should
I have done several hours of internet and USENET research and cannot find any information on the multiuser issue I am encountering. I have split my database into FE and BE versions. During testing with another user, both of us using local FE versions, any changes each of us make are only visible in our local copy of the FE, and in the BE only when opened on the separate machines. For Example: Changes made by user 1 can only be seen on his machine, both in the FE and BE versions of the database. Changes made by user 2 can only be seen on his machine, both in the FE and BE versions of the database. Does it matter how the users have the path to the BE version set up? (IE; S:\filepath vs. \\Servername\sharename\filepath) There is quite a bit of information I have found about multiuser databases, but it all seems to focus on record-locking strategies, not troubleshooting. For reference, I opened 2 copies of the FE (a local and a network copy) on my machine this morning and everything worked perfectly. Thanks for the help, Matt If user 1 adds or modifies data on his/her machine, then user2 will not see the new or modified data until user2 requeries the data. That can happen by doing a requery of the form, closing and reopening the table/query, closing and reopening the database.  SignatureLynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Access Junkie List: http://home.bendbroadband.com/conradsystems/accessjunkie.html >I have done several hours of internet and USENET research and cannot find >any [quoted text clipped - 27 lines] > Thanks for the help, > Matt > I have done several hours of internet and USENET research and cannot > find any information on the multiuser issue I am encountering. [quoted text clipped - 22 lines] > Thanks for the help, > Matt Are you expecting records form User1 to instantly appear on a form being viewed by User2? That will only work if the User2 form is opened or Requeried AFTER User1 has made the entry. When you open a form you have access to the records that existed at the time it was opened. To see new ones you have to close and reopen the form or issue a Requery command on it in code. Otherwise you have somehow gotten these front ends linked to two different back end files. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanks for the input. Unfortunately, I am still not able to see the records. I have a main form, with 2 subforms (datasheets) that are used in this DB. Is the subform part of my problem? Also, does the form requery if the datasheet is sorted? I assumed it did, but to be safe, we have tried closing and reopening the form but that did not work. I changed the linked table properties this morning to use the UNC path to the BE, and that is correct in both cases. Are there network settings that my sys admin should check into to see what is causing this problem? Thanks, Matt > > I have done several hours of internet and USENET research and cannot > > find any information on the multiuser issue I am encountering. [quoted text clipped - 32 lines] > Otherwise you have somehow gotten these front ends linked to two different > back end files. > Thanks for the input. Unfortunately, I am still not able to see the > records. [quoted text clipped - 8 lines] > Are there network settings that my sys admin should check into to see > what is causing this problem? The only other thing that would explain it is if there were a filter or query criteria that was filtering out records entered by the other user. Just to clarify. User1 can open the table link directly (forget the form) and cannot see records entered by User2? If that is true then the two users are not linked to the same back end. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com There is no filter that should be affecting the records. And we seem to be looking at the same file. After a call to our IS department which resulted in them changing some of the permissions on the folder where the BE lives, we tried adding a new record. It did not show up, so we went to lunch. After lunch, the record was available in each FE DB. It appears there is upwards of a 30 minute delay before the records are available. Doesn't that seem excessive? > The only other thing that would explain it is if there were a filter or > query criteria that was filtering out records entered by the other user. > > Just to clarify. User1 can open the table link directly (forget the form) > and cannot see records entered by User2? If that is true then the two users > are not linked to the same back end. > There is no filter that should be affecting the records. > [quoted text clipped - 4 lines] > available in each FE DB. It appears there is upwards of a 30 minute > delay before the records are available. Doesn't that seem excessive? Never seen anything like that. Does the machine where the file resides by any chance have AntiVirus software that might be scanning the file on every modification? Otherwise it makes no sense. If the front end shows the record as no longer "dirty" then it HAS been written to disk. If it was taking 30 minutes to be written to the file then it would take 30 minutes for the front end to save the record during which you would not be able to do anything else. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.