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

 

[Dave Patrick]

Sounds like a permissions problem on SQL server. Are you using Windows
authentication? Does 'domain users' group have datareader, datawriter
permissions to the database?

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| 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
|