Page 1 of 1

Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 09:00
by Anakha56
Morning All,

So how do I go about accessing our one SQL database through MS Access 2010?

Thank You!

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 09:07
by doo_much
Data tab > Click from other sources > click From SQL server and follow the instructions?

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 09:45
by Tribble
Same way you did in 2007 :D (I guess)

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 09:57
by Anakha56
Never did it at all. So I have no idea how to do it in 2003 and 2007...

@ doo I dont have a SQL option, looks like I am going to have to use a ODBC link...

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 09:59
by doo_much
An I am sooo wrong... That's in 2007.

2010 is going the .net route and works with connections apparently. :?

More here

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:15
by Tribble
I can help you Anky - if you would like.

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:18
by Tribble
You are on the right track. Use the External Data ribbon and ODBC Database. Link to your tables that way

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:23
by Anakha56
Yeah I have done that, now to somehow organize and sort to input the new data...

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:28
by Tribble
You can create forms automatically - use the Create form or form wizard options. I like the autoforms because if you have set up the relationships correctly - then it automatically adds the subforms for you

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:37
by Anakha56
Dont think I will need forms just yet ;). I will be playing around with it on night shift, just waiting for the part info to be given to me...

Re: Access a SQL Database through MS Access 2010?

Posted: 29 Jul 2010, 10:47
by Tribble
Well I know a little about using the two together - so if you need questions answering - you know where to find me :lol: Play nice!