DAO/ADO recordset as form recordsource??
hi reid
who told you not to link the tables into the frontend? if not linked you
will have to use passthrough queries which will result in read only
datasets.
link them as you would with a access backend and make sure on each table
a unique or primary key is defined. then it works just like you are used
to.
regards
henry
--
Ich beantworte keine Fragen per E-Mail auf Postings
Reid Kell schrieb in Nachricht ...
Quote:
>I have a multi-user Access 97 application connected via ODBC to SQL 7.
I'm
>not quite understanding the concept of form recordsources. I'm told
that I
>don't have to link the SQL tables in the front-end app. If not, what do
I
>use as a RecordSource for forms? I know how to use DAO/ADO recordsets
in
>code. What am I missing? What's the best method for a form's
RecordSource?
>Any help is appreciated.
>--
>Reid Kell
>Lockheed-Martin, IBS
