Many questions from newbie, please.

[suntisuka]

I am new on AccessXP with SQL Server 2000 linked table and haven't build my
system from this environment. My background is I have programmed by using
Access linked table with DAO for years and always use Access form built-in
features like find, sort, filter, export, ... to support user operations.

Now Before I step into new environment, I have some questions to ask the
expert to decide what should I design my new system.

1) When I reference to recordset from form (Me.RecordsetClone), It always
returns DAO recordset. Is it still true in Access project ?

2) Some article said that using DAO to access data in non-Jet database is
very slow. Have any solution to avoid this problem ?

3) If I use ADO as form's RecordSource, Can user still operate on form (add,
edit, delete, find, sort, filter,...) as same as do on table/query as form's
RecordSource ?

4) By limit the number of record displayed in the bound form, Suppose 100
records, If user is at the last record and want to see more, How can I order
Access to retrieve next 100 records ?

5) Suppose I do not set limitation in (4) and there are million of records
in a table, How many records does Access retrieve into cache at a time? And
Do you have any experience in performance problem for such environment ?

6) Have any resources, web pages explain the differences between develop
application by using Access data bound form and SQL data bound form ?

7) Any more suggestions are welcome.

Thanks in advance,
Suntisuk

 

[Sapphire]

1, 2, 3) Always use ADO in ADP.

4) To retrieve more records some action has to be
performed. Right? Like a next button is pressed or
something is chosen. Requery at that event.

5) Yes, there will be performance issues if you do not
set the limit to the records access retrieves.... because
access form loads only after all the records are
retrieved.

I hope this helps