By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Upsizing issues

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.