Is there some special trick that needs to happen?

[Johnfli]

I have Access 2k on my PC. I setup a system DSN on my machine so I can
conecct to my SQL7 database.
All looks good, I can see the data. When I modify or add data, it doesn't
save it to teh SQL server.

Is there some special trick that needs to happen so that it saves?

 

[Rick Brandt]

I have Access 2k on my PC. I setup a system DSN on my machine so I can
conecct to my SQL7 database.
All looks good, I can see the data. When I modify or add data, it doesn't
save it to teh SQL server.

Is there some special trick that needs to happen so that it saves?

Do you get an error or are your keystrokes ignored? One of the two should be
happening. The latter usually means that the table has no primary key on the
SQL Server causing the link to be read only. The former is usually explained by
the error message.

 

[Johnfli]

Nope, no errors. I type to my hearts content. But when I close access,
everything I entered is not replicated to teh server.