I use a ListBox to Open Query
private Sub ListBox_AfterUpdate()
DoCmd.OpenQuery "q1",acViewNormal,acReadOnly
end Sub
The problem is That when i click in the list box the next time I fou...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20409345.html
Zones:
DatabasesDate Answered: 11/27/2002 Grade: A Views: 4
OS -> WIN Server 2000
Local DB -> SQL Server 8.0
Remote DB -> Oracle 8.16
Have created a linked server from my SQL Server to Oracle db called LinkedServer. Trying to get data from a view an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20786633.html
This is what I have so far for a query. It returns records on T-SQL
SQLQUERYSTRING =
SELECT COUNT(*) FROM
OpenQuery(AS400,
'SELECT SUBNO, PERNO, cgrpid
FROM hmodta.hmembp
WHERE cgrpi...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21159823.htm...
Zones:
ASPDate Answered: 10/14/2004 Grade: A Views: 13
I am still unable to pass a variable within an open query statement]
select * from openquery(newconn, 'Select
''@data''
from a db')
also is there a way to do date add within an open query
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21216231.html
Hello all,
I am trying to access a legacy database, through their ODBC driver, that has been implemented using the Microsoft SDK ODBC drivers version 1.0.
In their database they have a field ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21744864.html
I've got something bugging me, so I thought I'd throw it to the Gurus for some thoughts/advice:
I recently have been trying to incorporating the DAO execute method. It seems that for action que...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21792698.html
Zones:
MS AccessDate Answered: 03/30/2006 Grade: A Views: 0
am using sql server 2005. Is there any limitation when I use the openquery option ? If so is there a work around?
Thanks
Raj
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2288...
I want to make query to multiple servers and the query is run on remote server. So that, I tired that the following code.
--(The @svr_name will change during program runtime.)
DECLARE @svr_name...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10264953.html
Hi All,
I have trigger that sends data from one table to another.
I am using the Openquery statement within the trigger to send the data.
However when I Insert anything with an apostrophe ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20560483.html
I need to write an update trigger in SQL 2K. I have two copies of the same table table on 2 different servers, for example. When a record gets updated in one, then the trigger updates the other t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20666719.html
