cant link forms using rowguid

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2000 front and SQL 2000 Back

When linking the child and parent fields in access 2000 I am using a
uniqueidentifier named rowguid from the SQL server backend. Apparently
access does not like the rowguid as a means of connecting a subform to a
form. Has anyone else run into this problem.
 
Hum, do you see any child records in the sub-form?

I would try adding a time stamp, and further exposing this time stamp (both
tables should have one exposed).

I would think as long as the link/child/master fields are set, this should
work....
 
I do not see any Child records, but I know they exist. When adding records
in the subform is enabled, the rowguid from the parent appears in the new
record. I'm not sure how the timestamp would help?
 
I just tried adding a record to the subform in question, after updating the
record dissappears from the subform, however, it definately exists in the
backend.
 
Back
Top