On the backend, updates occur fine (in a SQL table). However, in Access
97, the error for
any updates is "This record has been changed by another user......",
when in fact, it's only being editted at the time. I've researched what
is on-site but can't find anything specific.
I created tables, triggers, and indexes in Sql 7.0 and
am linking the tables to an Access 97 database and never
got this problem when mixing SQL 6.5 with Access 97.
Question #2: I sorely miss being able to restore a single
table in SQL 7.0, like I did in SQL 6.5. Read something about a
solution which is restoring entire database to anotehr
location and then restoring table over the other. But
will it restore permissions, triggers and indexes