RefreshLink and SQL Server

[Guest]

Hi

I have an application in Access2003 with linked tables. When I create the
links manually (picking DNS etc) I have no problems. When I then try to
recreate the links programatically (different users) I am not able to add
any
records to any of the tables! If I erase all the linked tables and reconnect
manually with the other user I have no problems!

I am using the relink code from
http://support.microsoft.com/default.aspx?scid=kb;en-us;159691


Any and all suggestions Welcome!!!

Regards

Meir

 

[Robert Morley]

It sounds like it's not properly identifying the Primary Key (or at least a
unique identifier) for each of the tables. I'm not entirely sure how you do
that programatically, as it's been a while since I've played with linked
tables, but that may get you pointed in the right direction at least.



Rbo

 

[Guest]

Robert Hi

Thanks for the idea!! You 100% correct the upsizing from Access didn't
create the Primary Keys!!!

Regards

Meir