Linking Access 2002 & MS SQL Server 2000: Please Help

[Tobin]

Very simple question:

Can you edit or input new data into a linked table in Access and expect the
changes to appear in SQL Server?

Or is it a one way street: SQL --> Access?

Thank you very much!

 

[GVaught]

Is this a trick question?

If the table is indeed linked from SQL Server data you enter through Access
will indeed appear in the SQL tables. This is why some people build Access
frontends to link to SQL Server tables.

 

[Tobin]

Ha. No, this is not a trick question.

I had linked a MS SQL Server 2000 table in MS Access 2002. However, when I
added a row to the table in Access, having closed the table, I was
disappointed to find no updated row when I reopened the linked table.

Would anyone care to tell me where I'm going wrong?

I simply use the "Get External Data" option on the File menu.

Thanks,
Tobin

 

[Rick Brandt]

Ha. No, this is not a trick question.

I had linked a MS SQL Server 2000 table in MS Access 2002. However, when I
added a row to the table in Access, having closed the table, I was
disappointed to find no updated row when I reopened the linked table.

Would anyone care to tell me where I'm going wrong?

I simply use the "Get External Data" option on the File menu.

Are you sure you "linked" and didn't "import"? If you are allowed to make the
entry and you don't get an error message, then the data should have been saved
to the table on the server.