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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do multiple users save in a record in a form at the same t
Hi,
Thank you for your immediate response, I have tried that and all the does is allow the other users to look at the records in the form, but they cannot save any additional records or delete any. I tried creating a workgroup, but not sure how that works exactly. Any additional help will be appreciated. Thanks again, Mark "BabyATX13 via AccessMonster.com" wrote: Mark, Try Tools, Then Options, Advanced tab, and under “default open mode” select radio button shared. This should work K Board MRUDAS wrote: Hi, I have been trying to set up our access database to support multiple users at the same time. What I would like to happen is allow a number of people and myself have access to ACCESS at the same time (be logged in), enter what ever records we need to in the form and then save at the same time. Instead of having 1 person at a time in access and saving it when ever the other person is out. Can someone please help with how to fix this? (I do not know how to code in access, but I am fairley capable with most of the features). I am currently runnig Access 2003, and I stopped using a .mdb file and started using the workgroup .mdw file. Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
#2
|
|||
|
|||
Mark,
Have you tried to set the default record locking to no locks? K Board MRUDAS wrote: Hi, Thank you for your immediate response, I have tried that and all the does is allow the other users to look at the records in the form, but they cannot save any additional records or delete any. I tried creating a workgroup, but not sure how that works exactly. Any additional help will be appreciated. Thanks again, Mark Mark, [quoted text clipped - 16 lines] Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
#3
|
|||
|
|||
Yes I have. I tried no locks and edited records. I also had the box checked
next to record level locking and tried it off as well. For some reason it does not want to connect and allow both of us to add to the database at the same time. Am I suppose to be using a Workgroup file or a regular MDB file? I tried both and it is still not working. I also tried to connect using workgroup administrator linking the databases to one mdw file. "BabyATX13 via AccessMonster.com" wrote: Mark, Have you tried to set the “default record locking” to no locks? K Board MRUDAS wrote: Hi, Thank you for your immediate response, I have tried that and all the does is allow the other users to look at the records in the form, but they cannot save any additional records or delete any. I tried creating a workgroup, but not sure how that works exactly. Any additional help will be appreciated. Thanks again, Mark Mark, [quoted text clipped - 16 lines] Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
#4
|
|||
|
|||
what does your DDE Oporations say?
MRUDAS wrote: Yes I have. I tried no locks and edited records. I also had the box checked next to record level locking and tried it off as well. For some reason it does not want to connect and allow both of us to add to the database at the same time. Am I suppose to be using a Workgroup file or a regular MDB file? I tried both and it is still not working. I also tried to connect using workgroup administrator linking the databases to one mdw file. Mark, Have you tried to set the default record locking to no locks? [quoted text clipped - 16 lines] Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
#5
|
|||
|
|||
Ignore DDE requests is NOT checked
and Enable DDE request is checked "BabyATX13 via AccessMonster.com" wrote: what does your DDE Oporations say? MRUDAS wrote: Yes I have. I tried no locks and edited records. I also had the box checked next to record level locking and tried it off as well. For some reason it does not want to connect and allow both of us to add to the database at the same time. Am I suppose to be using a Workgroup file or a regular MDB file? I tried both and it is still not working. I also tried to connect using workgroup administrator linking the databases to one mdw file. Mark, Have you tried to set the “default record locking” to no locks? [quoted text clipped - 16 lines] Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
#6
|
|||
|
|||
I dont know what to tell you then.
My DDE operations are set to enable DDE refresh, Default file format is Access 2002-2003, default open mode is shared, default record locking No Locks, open databases using record-level locking is checked, OLE/DDE timeout (sec): 30, Refresh interval (sec) 60, Number of update retries: 2, ODBC refresh interval (sec): 1500, and Update retry interval (msec): 250, and I have had no problem sharing database with other user. Sorry I couldnt be of more help K Board MRUDAS wrote: Ignore DDE requests is NOT checked and Enable DDE request is checked what does your DDE Oporations say? [quoted text clipped - 11 lines] Thank you in advance for your help, Mark -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200508/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating Records in tables automatically | peterg290935 | Using Forms | 8 | June 22nd, 2005 08:12 AM |
Modify a record and save as a new record | Detroit | Using Forms | 3 | June 17th, 2005 11:05 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Inspect record, replace null field on output | RNUSZ@OKDPS | Setting Up & Running Reports | 3 | April 5th, 2005 04:27 PM |
Two versions again-language issue | Otto | Setup, Installing & Configuration | 3 | May 28th, 2004 04:57 AM |