SQL service connection

[selma_]

I would like to create a menu in Microsoft Access. I know how to do it if I have a database in Access,but now I would like to create a menu for my database in SQL. So my question is how to connect to SQL from Access?
how can I create a menu in Access from which I can directly connect to SQL database?

thanks ;-)

[dcrake]

alot depends on what connection method you want to employ. You can use DAO, ADODB or even DNS. ADODB is the easiest way. Alot also depends on your vba skills. Access will let you link tables from an SQL database but you need to create the DNS first and point to that.

David

[selma_]

ok, thanks I created DNS and imported my database.

but now I am wondering if I can create one button in my menu,that will connect me directly to the SQL server in just one click...and will show me my databases in SQL??? do I need some code for that or..???

So, I actually want to create a menu in Microsoft Access from which I will be able to see all my databases in SQL,import some data and so on.

[dcrake]

You don't want to be importing them you should be linking them. You should see a SQL icon next to the table name. This shows you it is linked.

[selma_]

so, how can I do that ?

[dcrake]

Use File ? Get Eternal Data > Link Tables

Then change the files of type to ODBC Databases() usually the last in the list. Then naviage to your SQL server nominating your DSN.

David