question on FE/BE about transactions

[keyur]

Hi

I made a FE/BE type of database (Access 2000) for the first time so I was wondering whether do i have to use the transactions to avoid possible conflicts. I found the code at Microsoft site.

Thanks

 

[ReAn]

No, your fe/be will automatically lock records in use so there is no confliction, whoever edits 1st has priority.

 

[keyur]

hi

well got another question. Say the are 2 user adding a new record add the same time. now the record doest gets entered into the table until the user exits the entry form. so would each user's record have an unique ID (set to autonumber).

also say 2 user are trying to edit same record. will it automatically take the latest changes or wil it give some kind of erro. in the same situation. say one of the user decides to close the form. will he/she be able to close without any errors or confirmation boxes. if no is it possible to avoid them or atleast customize them.

sorry if i am not making myself clear because i am confused as well.

Thanks again.

 

[Mile-O]

Say the are 2 user adding a new record add the same time. now the record doest gets entered into the table until the user exits the entry form. so would each user's record have an unique ID (set to autonumber).

When a new record is started (or Dirtied) then an autonumber is immediately created to relate to this record (if an autonumber field exists in the table). If the record is cancelled halfway through then the autonumber that was reserved is lost. This means that two records save at the same time can't have the same autonumber - there can be no conflict this way.

Second question, typically a box appears saying "someone else has made changes what do you want to do? Save new changes or Cancel new changes.

 

[keyur]

hi

thanks mile. thts y i wanted to use transactions. what i m thinking is adding a save button so the transactions is committed only if 'save' is pressed. i am trying that right now. but i cant get the code (found here) to work with my other events. It works fine if the form doeesnt have any of my events and i cant figure out whts interfering.
do u think this is possible? because if not i dont want to waste time on this.
Thanks again.

 

[ghudson]

Check our my A better mouse trap? posting. Pay attention to how I am not allowing a user to save a record unless they click my custom save button. Also, you can only save a record if the record set is updatable.

 

[keyur]

THanks a lot ghudson.