Q: Bound vs unbound controls & linked tables

[MarkD]

Using Access 2000 and Oracle 8i.

I have a form that's bound to a single linked table in
Oracle. I've noticed a significant decrease in the speed
of accessing the data and I think it's because we're using
Access form programming for non native tables.

I'm thinking that I can create an access form that instead
uses unbound controls and passthrough queries for the data
entry screen. The question is, is this the best route to
go? Having bound controls is much easier and I'm wondering
if there's a way to speed up things with the bound
controls.

Thanks,
-Mark

 

[Larry Linson]

My experience with Access ODBC clients to server databases is that
performance is often abominable if you open a form against an entire table
or query (as is common in sample Access-only applications), but often much
improved if you retrieve only the information you really need (just those
fields of immediate interest, and very often just one record if it exists,
or none if it does not).

Larry Linson
Microsoft Access MVP

 

[MarkD]

Thanks for the insight. The big issue I'm running into is
when the form is first opened, and the user wants to add a
new record, Access seems to take minutes to respond --
making me think Access is fetching all the rows. I don't
want it to do that.

I've worked with unbound forms and, along with passthrough
queries, it seems like the better solution. But I haven't
had much experience and was hoping to hear from people
like you who have.

-Mark