K
Keith G Hicks
I have an MS Access 2k front end connected to an MS SQL 2000 back end.
All of my tables are indexed appropirately and they link and are updateable.
I have a view that I need to link.
When I link it manually, I can select the field that makes the recrod unique
when the messsage "Select Unique Record Identifier" pops up.
But I do most of my table/view linking in code. Since my tables are indexed
on the back end, they work fine. But the view is not indexed on the back
end (I already walked thru that nightmare and was not successful because of
several roadblocks I don't want to overcome right now).
So the question is, how do I handle the "Select Unique Record Identifier"
when I link the view through code in the front end?
Thanks,
Keith
All of my tables are indexed appropirately and they link and are updateable.
I have a view that I need to link.
When I link it manually, I can select the field that makes the recrod unique
when the messsage "Select Unique Record Identifier" pops up.
But I do most of my table/view linking in code. Since my tables are indexed
on the back end, they work fine. But the view is not indexed on the back
end (I already walked thru that nightmare and was not successful because of
several roadblocks I don't want to overcome right now).
So the question is, how do I handle the "Select Unique Record Identifier"
when I link the view through code in the front end?
Thanks,
Keith