.AccDB file connecting to SQL Server

Question

How can I create a new .ACCDB file to connect to an existing SQL server database?

Answer 1

1. Open your Access database.
2. From the [External Data] group, select [ODBC Database].
3. Select "Link to the data source...", and click OK.
4. Select or create a DSN to provide connection details.
5. Select the tables/views you want to link, and click OK.

Let us know if you need help creating a DSN.

"KM Kwun" wrote in message news:*** Email address is removed for privacy *** .com...

How can I create a new .ACCDB file to connect to an existing SQL server database?

---

Regards, Graham R Seach Microsoft Access MVP Sydney, Australia

Answer 2

The proper name for "child sheet" should be "subdatasheet". Master sheet and subdatasheet are linked by a field. We can click on the leftmost [+] sign of the master sheet to expand the subdatasheet in an ADP project. I don't know if it can be done in the ODBC interface.

Answer 3

ODBC is just the interface, and as long as you have an interface, you can create datrabase objects. You issue DDL instructions in an Access passthrough query or an ADO Command object.

But when you say "child sheet", I wonder if you mean a user'form", in which case the answer is no. To do that, you need the Access object model.

"KM Kwun" wrote in message news:*** Email address is removed for privacy *** .com...

Thanks for your answer. I want to know if I can modify the structure of the table or create parent and child sheet via ODBC.

 

---

Regards, Graham R Seach Microsoft Access MVP Sydney, Australia

Answer 4

Thanks for your answer. I want to know if I can modify the structure of the table or create parent and child sheet via ODBC.

Answer 5

In addition to the steps Graham has provided, here's a link you might find helpful:

Import or link to SQL Server data

http://office.microsoft.com/en-us/access-help/import-or-link-to-sql-server-data-HA010200494.aspx

Hope this helps!

Kathy