We're using Access97 (SR1) + Btrieve ODBC2.04 as front-end for btrieve
When trying to process whole btrieve table - for example importing data
from Btrieve to Access like
INSERT INTO Access_Table
btrieve table gets locked until query is finished and nobody else can use
it - pretty * in multiuser environment. I wonder WHY as I only READ from
it. Is there a way how to force Read-Only, NoLock connection? Maybe using
Access' VisualBasic to create connection.
Is Intersolv ODBC any better?
Thank you in advance