RefreshLink and SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mrrcomp - 07 Oct 2005 15:25 GMT

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

Reply to this Message

Robert Morley - 07 Oct 2005 15:39 GMT

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

> Hi
>
[quoted text clipped - 14 lines]
>
> Meir

Reply to this Message

mrrcomp - 08 Oct 2005 18:56 GMT

Robert Hi

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

Regards

Meir

> 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
[quoted text clipped - 21 lines]
> >
> > Meir

Reply to this Message