Discussion Locked
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.
Trending Networks posts
Sort by Trending
Question Unanswered
How Can IT Teams Detect Hardware Bottlenecks in Business Networks?
0 helpful
0 replies
Question Locked
Using multi-NIC setup for NAS + router — better than VLAN?
0 helpful
4 replies
0 helpful
5 replies
Question Locked
Unknown device connected to my network
0 helpful
2 replies
Question Locked
How to change public IP without ISP?
0 helpful
2 replies