Linking forms to tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I've read that you don't want to link your forms directly to tables, but
should instead link them through queries. Does this mean that I should
create a query for each table OR will I get the same effect by simply setting
the form's RecordSource to SELECT * FROM tblExample;?

I imagine that the latter is the preferred method, but I just want
verification.

TIA

Aaron G
Philadelphia, PA
 
Hi Aaron -- I seem to remember hearing this in some Access training I
attended through work but I don't remember hearing a legitimate reason other
than preference.

Now, with all that I've learned regarding Access, I have not found any
validity to this. I've built countless databases and I have never
encountered an issue with having the table as the source for the form.

Where did you obtain this advice?
 
Thanks for your response.

I've come across it several times throughout this forum. I assumed the
reasoning behind it has to do with performance in a multi user environment.
That's just an assumption, though.

Aaron G
Philadelphia, PA
 
Interesting -- Hopefully one of the MVPs can shed some light on this because
I cannot give a definitive answer since all I have is my experiences.
 
Back
Top