Search results for query: *

I have adp file and SqlServer 2000 working in runtime mode. when the user deletes row in Continuous form the application freezes and only the Enter key release it. Thanks for any ideas yaya

thank you!!

Hi!! How can i determine if i'am running then application in Run Time ?? thank you form any help!

I have Access 2000 adp file with SqlServer 2000, when I install the Access 2K RunTime the user not able to delete record in a continuous form, its looke like the form is not responding . any help will appreciate.

strSQL = "SELECT * FROM MyTable " CurrentProject.Connection.Execute "ALTER VIEW MyView AS " & strSQL

open the form with no records and let the user to decide which record to show.

try to run the Decompile command "C:\Program Files\Microsoft Office2K\Office\MSACCESS.EXE" /Decompile "C:\App.adp

why not to work with access 2000 mdb/mde ??? and then you have no problem. i do not see the big advantage of access project ADP

CurrentProject.Connection.ConnectionString

in my Office, on 3 different pc its working ok. Each pc has the SQL installed. I will try you'r idea. Thanks

I have a bound form in Access 2000 Project to table In SQL 2000 when the user try to Delete a record in the form Access is freeze and i must use ctl + alt + delete In My computer its working just fine Any sugestions? Thanks, Yair

Hello Try DoCmd.OpenForm "MyFrm", , , stLinkCriteria Form_MyFrm.ServerFilter = ""

Yes, the DoCmd.Close works OK. but the unload is cleaning the memory better . thanks.

when i write unload me or the form name i get Run Time error 361 Can't Load Or Unload this Object

Hello all !! Is it possible to close a form in Access Project with Unload Me (like in visual basic)??

OK

in you'r stored procedure you write: SET NOCOUNT ON And in the end SET NOCOUNT OFF ???

I'am using a stored procedure for the Recordet. You can NOT bind a form to a stored procedure that return Select * From #temp

Hi. I'am using the temp table only for view some data. the commandtimeout is 30 (the Default Value). I try to open a new project, but i grt the same result. I think that Access forms, can not be bound to a Recordset from a temp table.

Hi All!!! I am working in Access 2000 (ADP) with SQL Server 2000. when I populate a form with a recordset from a temp table. sometimes Access generates an error and close the program. any idea ??? Thanks.