two forms, same table source

[Pete Ruby]

I have a form (Form1) with multiple tabs to input info into a table called
"Table1", which is a linked SQL table. At one point, I found I had hit the
field limit per form. I still needed to add fields to my form so I created
a second form (Form2) that also inputed to "Table1". THe setup is as
follows:

The user selects an item to view from Form1, Form1 does an applyfilter for
that item. Then if the item has certain characteristics, Form2 opens, does
an applyfilter on the item and the user can input info for the record on
that form. When the user closes Form2, it runs a save record, closes, then
Form1 is still open.

But, sometimes when saving on Form2, the user gets an error saving the
record has been modified by another user. The user than gets 2 options,
Drop changes, or copy changes. They then loose the info they inputted.
This does not happen all the time.

I got the message earlier this week and found what I thought was the issue,
MS KB 278696 - "White Conflict Error When You Try to Update Records in a
Linked SQL Server Table". But I fixed that issue, but I am still getting
this issue.

Any Ideas? Or better way to handle the multi form issue?

Thanx,
Pete

 

[J. Clay]

It sounds like the table has a very large number of fields. Is there some
normalization that can occur to make the data a bit cleaner?

As for your current problem, you shouldn't have the record open and being
edited in two forms at the same time. This WILL cause a write conflict,
even if the forms look at different fields. In general, when dealing with a
linked table in Access, the SQL datasource doesn't care about fields, it
cares about records.

HTH,
J. Clay