SELECT statement as RecordSource

  • Thread starter Thread starter tina
  • Start date Start date
T

tina

hi folks,

i'm using Access 2K on Win2K Pro OS. my database is an mde, linked to a
backend mdb that will reside on a Win2K server. are there any significant
issues re using SELECT statements for my forms' recordsources instead of
query or table objects - such as speed, etc?

any comments are much appreciated!

tia,
tina :)
 
hi folks,

i'm using Access 2K on Win2K Pro OS. my database is an mde, linked to a
backend mdb that will reside on a Win2K server. are there any significant
issues re using SELECT statements for my forms' recordsources instead of
query or table objects - such as speed, etc?
Click to expand...

There might be a minute performance advantage to using a compiled
query rather than a SQL statement, but I've never noticed any
detectable difference. I routinely use SQL statements as rowsources of
combos and recordsources of forms.

John W. Vinson[MVP]
 
Back
Top