create a form using the wizard

[mikela]

Hello!!!

Is it posible to connect to a Sql server database from access form, creating the form using the wizard???

I could not find the way to select tables from SQL Server when using the wizard...

How could I do it???


Thanks a lot!

 

[KenHigg]

You'll need to connect to the sql table with the odbc admin then link to it in access.

 

[mikela]

ok...

But how can I do it?? Where do I put this odbc connection in the wizard?? I have no idea...

Do i need to create a new project on existing database and select an sql database??

 

[KenHigg]

First you'll need to find the odbc admin program on your computer. Then here's a site that steps you through setting up the datasource:

http://www.simongibson.com/intranet/odbc/

 

[neileg]

You'll need to link the tables to your Access application first. Then they'll appear in the table section of the wizard.