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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2006-05-22 : 15:17:09
|
| Hi I am trying, to query, from the SQL Server query analyzer MyTable, which is a linked table residing in Access, SELECT *FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="S:\MyDatabase.mdb"; User ID=Admin;Password=' )...[MyTable] Im not being allowed to do so:the error is the following:--------------Could not open table 'SHRTCKN' from OLE DB provider 'Microsoft.Jet.OLEDB.4.0'. The specified table does not exist.OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IOpenRowset::OpenRowset returned 0x80040e37: The specified table does not exist.].------------------------Does anybody have any comment?thank you |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-23 : 01:52:55
|
| Make sure the table name you have given exists in the databaseMadhivananFailing to plan is Planning to fail |
 |
|
|
DMcCallie
Yak Posting Veteran
62 Posts |
Posted - 2006-05-23 : 10:36:14
|
| I setup an ODBC to the Access DB, then use the ODBC name and setup a linked server. Then use select * from openquery (linkedservername, 'select * from mytable') .We also had a problem with McAfee Viruscan 8.0.0 patch level 10 where the buffer overflow protection would not allow us to access linked servers with Access databases. Linked SQL Servers worked fine. We applied patch level 11 and that fixed the problem... |
|
|
|
|
|
|
opendatabase and linked tables