Linked SQL tables issue 1

[scotttom]

Hi There,

I have an Access 2003 Front end and MSSQL 2000 backend. Everything works fine on my development sql server. I detached the database, made a copy, and attached it on my production server. I changed the IP address on my ODBC DSN to the production server and used the Linked Table Manager with the Always Prompt for new location option checked.

Displaying data from the production server works flawlessly, but if I try to update data I can't.

My guess is that it has something to do with Linking the tables because if I link a table by using Get External Data..Link tables it works until I use Liked Table Manager to update the links. What am I doing wrong?

Thanks for the help in advance.

Scott

 

[jsteph]

It sounds like a sql permissions issue to me,
--Jim

 

[dhookom]

Do you have a primary key in the SQL Server table? Does Access identify the primary key?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]