Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
projecttoday
Starting Member
31 Posts |
 Posted - 2010-04-19 : 20:55:09
|
| I'm trying to make my first-ever pass-thru query in Access 2007 with SQL Server 2008 Express. Whenever I try to create a simple query I get Invalid Object Name 'dbo.tbl... #208When I created the data source, the connection test was successful.The following runs:SELECT * from sysobjectsIt produces 1999 records but the tables aren't there.I probably left something out or specified something wrong. This is my first attempt. Can anyone see what I did wrong or help me solve this? |
|
|
projecttoday
Starting Member
31 Posts |
Posted - 2010-04-20 : 00:44:02
|
| Found it. I didn't have the Machine Tab configured. |
 |
|
|
|
|
|
Invalid object on pass-thru query