Discussion Locked

Access and SQL Server

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an access live diary running on my Win2k server. sql server is running, the database opens fine on my server. However on my win 98 client, with ODBC Sql server installed, the access database opens but any data within the fields of the diary are comming up with Deleted and covered by the # mark.

1 reply

by roc180

I'm assuming from your explination of the problem that SQL Server is the backend DB, while Access is your user frontend, with linked SQL Server tables. I have had the same problem, with linked SQL server tables. If you open the linked table you get the deleted message, but if you query the table the rows will show up fine. I have not found a sure fire fix, sometimes if you delete and relink the table that will fix the problem. Instead of linking the SQL tables into Access use pass-through queries and ADO for data retrieval and updating.

Good Luck
Neal Martinelli

This discussion is closed to new replies.