I face # Delete problem, Please help me

[accesser]

Dears,

I am working on Access 2002. I made a Data Source Name (DSN) to connect me to the Microsoft SQL Server Desktop Engine (MSDE). This ODBC connection works very fine and I can make Importing of Tables from this MSDE database very easly.

Becasue the system I works in is time sensitive which means that the millisecond makes difference, I need to replace the Import table by a Link table. As known, the Link provides fast reflection in the database (Any changes in MSDE reflected directly in the Access 2002 linked table)

What was happening after I made the Link Table is that all the data in all the cells of the Access 2002 Link table appears #Delete. I dont know why this happens. What I need to mention is that the front end application of the MSDE always in running. (It is used as a 24 hours recorder of all the events)

PLEASE HELP ME

THANKS

 

[ghudson]

You need to close the table and then reopen it.

I hope that your users do not have direct access to the table or any of the db objects. Users should access and interact with the data through forms.