Using access forms to read data from SQL databases

[Tom Bombadill]

Hello,

Forgive me if this sounds a little elementary to some of you out there, but
is it possible to use Access and Access forms as the front end to input/read
data to/from SQL databases?

I know how to create SQL databases and all I really need is one table with
the list of people and different fields for various comments to be entered
about them.

What I don't know is whether and how I can create an Access interface for
it, which will allow me to read and write data to the table, let me do
searches by different criteria and let me print it also.

Any suggestions or links would be appreciated.

 

[Kevin3NF]

The best place for this would be the Access Help topic: Import or link data
and objects

Yes, you can link to SQL Server tables and create all sorts of forms,
queries, reports based on the table.

File>>Get external Data>>Link tables

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Tom Bombadill]

Hi Kevin,

Thanks for the reply. Do I need to create an Access DB first? Cause that
option on the File menu is greyed out. As you can see, I'm not much familiar
with Access.

 

[Kevin3NF]

Yes. The link definition will reside inside the database, so you do need to
create it first. Please make sure you have a backup of the SQL Server, or
are working in a test system.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.