S
Susan via AccessMonster.com
I have several small access databases that store information that hasn't
been built into our app (sql 7) yet. Until this past week I was using
Access 97, and storing the GUID from the SQL 7 tables I wanted to link to
as a text field in Access. This allowed me to populate the tables using
subforms and also to run reports combining the sql tables and the local
tables from Access.
Last week, the databases were converted to Access 2003. With this change,
the SQL Guids can't be inserted into the local Access tables as text - the
content becomes unreadable. I can covert the text fields to Access
Replication IDs, and the subforms then populate the replication ID fields
correctly. However, I don't get any results from my queries if I try to
join the sql table and the local access tables on the GUIDS/replication
IDs. I realize that I can join them in a WHERE statement using
stringfromGUID, but slows everything down, if it doesn't just timeout.
I welcome any ideas, Thanks
been built into our app (sql 7) yet. Until this past week I was using
Access 97, and storing the GUID from the SQL 7 tables I wanted to link to
as a text field in Access. This allowed me to populate the tables using
subforms and also to run reports combining the sql tables and the local
tables from Access.
Last week, the databases were converted to Access 2003. With this change,
the SQL Guids can't be inserted into the local Access tables as text - the
content becomes unreadable. I can covert the text fields to Access
Replication IDs, and the subforms then populate the replication ID fields
correctly. However, I don't get any results from my queries if I try to
join the sql table and the local access tables on the GUIDS/replication
IDs. I realize that I can join them in a WHERE statement using
stringfromGUID, but slows everything down, if it doesn't just timeout.
I welcome any ideas, Thanks