Linking forms to tables

[Aaron G]

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

 

[xRoachx]

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?

 

[Aaron G]

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

 

[xRoachx]

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.