Link table from SQL Server

[Guest_imported]

Hello, I am using Microsoft Access97 and using a linked table from MSQL7.0. I can link the table with no problem, but when I try to add data or change data, 1 of two things seem to be happening. 1ST I will get a message saying that someone else has changed the current record... which is impossible, since I am the only one who has access to this db... after while it will let me add records, however, when I look at the linked table, every other row is filled across with the word #DELETED<br>
When I look at the table using SQL Enterprise Manager, everything looks fine. Does anyone know what is going on here?

 

[Shirley]

My sugestion to link the table , but develope you own table with the same fields and use an delete and append query to insert all the data to the table that you developed. When a table is linked the changes that are made may not be completly saved. I did that once and ened up doing what I suggested, it is less of a pain.

 

[Guest_imported]

Thanks for the reply. So what you are saying is we should keep two tables, one in Access, and one in SQL Server. Then we work on the one in Access, append that table to the one in SQL, then what? I'm sorry, but I got lost somwhere... <p>John Vogel<br><a href=mailto:john@computerwiz.net>john@computerwiz.net</a><br><a href=

http://computerwiz.net>ComputerWiz</a><br>

 

[Shirley]

Yes keep the two tables, linking a table takes up little space in you memory. Importing the table will take up the amount of memory that a normal table would. What I am suggesting is to develope a delete query on Access to delete all information in the table on your database and then from the linked table developed a append query to the table you used the delete query on in your database. The table on the server is automatically update, this process I described will update the table on your database. You can even set up a marco connected to a button that will do the whole process for you if you want. I hope this helps.