Recent content by jacq

Haven't ever tried a pass-through query. I have now created three stored procedures just to get the thing up and running (have one years worth of work to do in 5 weeks!!) so i'll probably try it when i have some more time. Thanks...

According to Microsoft Help and Support: Microsoft Access forms will only allow you to edit data from an ADO recordset if the ADO recordset is created by using a combination of the MSDataShape and SQL Server OLEDB providers. I have also tried changing the select from a WHERE to INNER JOIN but...

In case anyone is interested, i changed my stored procedure to include only one table (it previoulsy had 3 tables joined) and it allowed me to pass a parameter and return an updateable recordset using the code as RoyVidar suggested. Id does say in the MSDN site that you can have joined tables as...

Thanks, but it still doesn't work. I have used those two articles before and they helped me a lot. I have decided that it can't be done and will just use dsn links instead. Thanks for your help anyway...

Thanks I tried that and am still getting This recorset is not updateable. This is my full code, is there something else that I am missing? Set cnnServer1 = New ADODB.Connection Dim prmCallID As ADODB.Parameter With cnnServer1 .Provider = "MSDataShape" .Properties("Data Provider").Value...

Hello I have two methods for a recordset based on a stored procedure. Without parameter (creates an editable recordset): Set rstSP = New ADODB.Recordset With rstSP .Source = "usp_getOpenCalls" .ActiveConnection = cnnServer1 .CursorType = adOpenKeyset .LockType = adLockOptimistic...

i do a similar thing. i have my main db with it's own tables, and then links to the tables in the web based db. every time i download the db i run queries etc to copy the new data from the linked tables into the live tables, clear out the data from the linked tables and upload the empty...

thanks, but isn't that javascript. i have some information in a form that i want to pass to the url. when i tried to do it in javascript i could redirect the page, and retrieve the values from the form in the second page, but i couldn't mix the asp with the javascript code to pass the variable...

if i run this from page1.asp: <form action=&quot;page2.asp&quot;> and on page2.asp write: request.form(&quot;field1&quot;) i get the value from field1, page1.asp. OK if i use: <form action=<%call function()%>> and the function is: if radio button = 1 then...

i am very new to this. i am running xp professional and iis on my pc. i am trying to create cookies but it does nothing. i uploaded the same asp pages onto my isp they were created fine. are there some settings i should know about? jacq

i am using user level security, but i also store the logins in a table with a date so that users have to change their passwords every two months (i initially set up the code to store all information, so by default i have the password but i don't want the users to know). the dB user/administrator...

i have a dB with many users who frequently forget their passwords (i have a table - tblName - that contains all the users passwords and logins). i tried to use object.NewPassword oldpassword, newpassword, but i can't set the object (user), as it wants the workgroup user, and won't accept a...

Thanks I have closed and set all recordsets to nothing. I have no open loops. If I run the code using F5 it locks, if I run the code using F8 it locks, if I put msgbox's in it locks. But it has run for me several times so I know intrinsically the code is ok.

I am having a problem with 3 specific forms that keep freezing, and when I look at Task Manager it says Not responding (it seems to be at between 12MB and 17.5MB). I think it is because I am manipulating a lot of data via recordsets. Is there any way I can somehow reset the memory halfway...

i am trying to create a report based on data i have inserted into a temporary table (each time the table is created it has different fields). i need to create a report based on the fields in the temporary table each time the user runs the report. i can createreport, i can createreportcontrol in...