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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-07-24 : 10:52:49
|
| Hi,I have a linked server to MS Access named SOES;File is called sop2k;Table is event.select * from openquery(SOES, 'SELECT COUNT(*) FROM "Event"') works fine-------------------------select count(*) from [SOES].[Event] select count(*) from [SOES]..[Event] select count(*) from [SOES]..[user].[Event] , etc(insert into …select * from [SOES].[Event] )returns: invalid object-------------------------------------------Any suggestions are greatly appreciated.Thx,Dobby |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-24 : 11:35:31
|
| select count(*) from [SOES]...[Event]dbname and owner between server and table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Linked server to MS Access