Write Conflict Issues

[AndrewsPanda]

I think I may have set up my forms and relational tables in a way that causes Write Conflicts.



Form 1 uses Customer table and stores all of the customer information.
Then 2 uses Customer table and also has a sub form which stores kit information.

Form 1 and 2 use the same fields for "Company name" "Company ID" etc etc so you bring up a customer on form 1 and press a button and it takes you to the same company on form 2. Both forms have fields from table 1 that store different information.

Eg: Form 1 has a notes field from table 1 that stores extra company info
Form 2 has a notes field from table 1 that stores extra kit info.

However I seem to be getting Write Conflict issues and other issues with this set up. Can anyone please shed some light as to why? Thanks

Customer table and kit table are related by Customer ID.

[AndrewsPanda]

It looks like I fixed the issue by having the button close the form it is on when it opens the next form.

However the issues remains that we have two computers on the one lan using the one Access. Both computers use the one Access file at the same time and there seems to be no way to set it up so they can both use the same file at once without getting write issues and conflicts. Any ideas?

[goodguy]

Read up Access Help on concurrency and record locking options.