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

 

[Alex]

Hi John,

did the upsizing wizard work fully?

have you got all your data across?

have a look at your data through the SQL enterprise manager if you have
it, if not open the tables directly in access. Can you manually
edit/insert data into the tables?

If you cannot then the most probable cause is missing indexes/primary
keys, if the manual edits work then check your forms for the 'unique
table' property, they have to be set to the table that you want to
update. Look into your query that the subform is running off as well.

Well a couple of things to look into. Given the data is eventually
getting into the table it is most probable that the problem is a form
issue/relationships in the data.

Good luck

Regards

Alex

 

[Sylvain Lafontaine]

For your first question, see my other post to W. Levine and take a look at
the previous posts in the newsgroup. Google have them all.

For your second question, it is possible that you mixed the DAO and the ADO
recordsets. ADP can manage both types but if you don't specifiate it, you
get a DAO recordset instead of an ADO recordset. For example, you must
write something like:

Dim rs As ADODB.Recordset
Set rs = Me.RecordsetClone
rs.MoveFirst

instead of just :

Dim rs As Recordset
Set rs = Me.RecordsetClone
rs.MoveFirst

Often, the second case won't work; especially if the order of References in
the VBA window is wrong.