Upsizing issues

[John]

Hi

I have just upsized an access backend/front-end mdb app to adp using the
2003 upsizing wizard. I have a couple of problem.

- On a master/detail form if I enter anything in detail form, I get the
error 'another user is using this record, discard, save to clipboard,.
save'. I try discard to get out of this. Funny enough when I look into the
table the data has gone in fine and the next time I open the form the
child/detail records are there.

- The recordsetclone isn't working.

I would appreciate if someone can help me to resolve these issues. Thanks.

Regards

[Rick Brandt]

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:42*********************@news-text.dial.pipex.com...

Hi

I have just upsized an access backend/front-end mdb app to adp using the 2003
upsizing wizard. I have a couple of problem.

- On a master/detail form if I enter anything in detail form, I get the error
'another user is using this record, discard, save to clipboard,. save'. I try
discard to get out of this. Funny enough when I look into the table the data
has gone in fine and the next time I open the form the child/detail records
are there.

- The recordsetclone isn't working.

I would appreciate if someone can help me to resolve these issues. Thanks.

For the first one try adding a Timestamp field to your table. I include
Timestamp fields in all SQL server tables that use text (memo in Access) or any
DataType that might have rounding errors between SQL Server and Access (Like
DateTime).

It might not be bad practice to simply include one ALL of the time, but I have
never had an issue unless one of the aforementioned field types was present.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com