| Author |
RefreshLink and SQL Server
|
|
| mrrcomp 2005-10-27, 8:32 am |
| 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/defaul...kb;en-us;159691
Any and all suggestions Welcome!!!
Regards
Meir
| |
| Robert Morley 2005-10-27, 8:32 am |
| 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
"mrrcomp" <mrrcomp@discussions.microsoft.com> wrote in message
news:A69DCCA7-A157-41DF-BBEC- E30BCD8FD6F0@microso
ft.com...
> 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/defaul...kb;en-us;159691
>
>
> Any and all suggestions Welcome!!!
>
> Regards
>
> Meir
>
| |
| mrrcomp 2005-10-27, 8:32 am |
| Robert Hi
Thanks for the idea!! You 100% correct the upsizing from Access didn't
create the Primary Keys!!!
Regards
Meir
"Robert Morley" wrote:
> 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
>
> "mrrcomp" <mrrcomp@discussions.microsoft.com> wrote in message
> news:A69DCCA7-A157-41DF-BBEC- E30BCD8FD6F0@microso
ft.com...
>
>
>
|
|
|
|