linking access to sql

• open the Access file that has all the user forms in it and go to Get External data.
• you want to create Linked Tables (different Access version give the option in different places - select Linked Tables when you get prompted)
• Choose ODBC and select the connection to your database or create a new one.
• select the tables you want to have linked
• you may be asked to identify which column is the PK in some tables
• presto! you have items in the Tables collection in Access. They have a different icon from a 'local' table to indicate they are linked to an external source

I have not done this myself in so many years that I wouldn't know where to start with the newer versions of Access but to answer your question

Yes, this can be done. A quick search on Google will probably reveal step by step instructiosn on linking a form in access to a SQL database.

A quick search provided ~ Use File - Get External Data - Link Tables. On the way through, create a DSN to give you access to your sql database.

I think this is what you are looking for Create Data Access Page