I've created a linked table from Access 97 to SQL 7 using a system DSN. I
can easily access the records but when I try to update the file it gives me
ODBC update on a linked table <table> failed.
I am running a desktop version of SQL server 7.0 and OS is win 98, my
application is runnng on Access 97
I would appreciate it if you could discuss me solution to your problem.
What seems weird is I tried it at home using Access 2000 and it works just