Local Wisdom \\Share EP12:Using Access 2007 to Query Microsoft SQL 2008 Part 1

We loaded up the Northwind Database on a fresh install of SQL Server Express 2008 and show you how to query it from Access 2007. Great solution once your Access Database gets too big and you need the performance provided by a robust Database server like MS SQL 2008, but don't want to loose the ability to query and report out of Access. Send requests for screencasts to share@localwisdom.com and follow us at twitter.com/localwisdom and visit us at http://blog.localwisdom.com

Category:

Science & Technology

Tags:

• screencast
• access 2007
• sql 2008
• query
• frontend
• backend
• microsoft
• sql express
• hybrid
• local wisdom
• share
• \\share

[lwinc]

@Aragan29 Just post a reply if your still having issues converting the sql.

[lwinc]

@Aragan29 In SQL you have "Select * from dbo.table". In access, it gets named "dbo_table". Thus your select statement in access becomes "select * from dbo_table". Pretty much the period gets replaced by underscores. To convert you need to do something like this:

SQL:

Select * from dbo.table t inner join dbo.table2 t2

ACCESS

Select * from dbo_table t inner join dbo_table2 t2

I show in part 2 going from Access to SQL at the 2:30 mark. EP12:Using Access 2007 to Query Microsoft SQL 2008 Part 2

[Aragan29]

What about the Queries? I have some queries that i made in SQL Server and i would like to use that code in access so i can create reports! i use copy and paste but access continue to give an error message dont know why... (im a noob :D) is there a "pro" way to do it?

[lwinc]

@conejo747 Thanks, I'm glad you found it useful!

[conejo747]

Nicely done! Thanks!