does anyone know what kind of locks links in Access97 to
tables in sql7 give? The tables in Sql change very often.
I am very suspicious concerning reading these tables from
Access through links. Am I right?

Are you talking about the schema changing on the SQL tables? Or just
the data? If schema, then you'll need to delete and recreate the links
because Access caches linked table schema info, and doesn't ever
refresh it. If data, then the default is to open a Dynaset, or keyset
cursor. If you want to eliminate the possibility of locks being held,
fetch data through pass-through queries, the results of which are
always read-only.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Tue, 4 Nov 2003 07:40:14 -0800, "Seven"
[quoted text, click to view]