SQL Server Access Form

Question

We need to create a SQL Server Access form. Probably just a Word Template. What SQL Server Access information would we necessarily need in a general SQL Server Access Form?

Thanks for your review and am hopeful for a reply.

Answer 1

Hi @Bobby P ,

>What SQL Server Access information would we necessarily need in a general SQL Server Access Form?

Did you mean creating your form template based on a SQL Server database? If I misunderstood, please let me know.

In order to design your form template based on a SQL Server database, you need the following information from your database administrator:

• The name of the server that contains the database that you will connect your form template to.

• The name of the database that you will use with this form template.

• The authentication required by the database. The database can use either Microsoft Windows authentication or SQL Server authentication to determine how users can access the database.

• The name of the table that contains the data that you want to send to the form or that will receive data from the form. This is the primary table. If you are going to use more than one table in the database, you need the names of those other, child tables. You also need the names of the fields in the child tables that have relationships with the fields in the primary table.

Please refer to the MS blog Design a form template based on a Microsoft SQL Server database to get more information.

Your issue is related to MS Access, if you have further issues about this, please add office-access-dev tag, people there will give you a better help.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Is this "Access" as in the product in the Office suite? It may be better to ask in a forum where they are familiar with Access...

But just a general answer: to access SQL Server from any application, you need to supply:

1. The client driver. This is sometimes implicit. But Access, you would need to specify which ODBC driver or OLE DB provider to use. I believe that ODBC is preferred. (But as I said, this is not an Access forum). The ODBC 17 SQL Server driver is the best choice.
2. The server\instance to connect to.
3. The database where the database.
4. Authentication information. This is either a username/password pair, or a keyword to indicate that you want to use Windows authenticaton.

And that's about it. There are plenty of other connection-string options, and some of them may be needed depending on your local circumstances. But in many cases you get away with the four above.