Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Roschigraz
- Order by date
-
SQL-Query blocked
@ Jerry Vba save event: I tried both: 1: set rst = dbs.openrecordset("Table",dbopendynaset,dbseechanges) rst.findfirst ... rst.edit rst!active = true rst.update rst.close 2: dbs.execute "Update .....", dbseechanges same Result.......- Roschigraz
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
SQL-Query blocked
newest infos..... ;-) the Problem does not depend on forms... Testenvironment: 1. I create a query "SELECT * From Table" 2. I try to modify a field in Table Scenario 1: * open query * modify Result: Timeout, because query-prozess (at sql-server) blocked update-prozess Scenario 2: * open...- Roschigraz
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
SQL-Query blocked
thank you but I have put the Data on a List (must have from customer :-() I can't find the reason for this problem, because I use the same technic in many forms an d also on tables with much more then 10000 records... only 1 table makes trouble :-(- Roschigraz
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
SQL-Query blocked
Hello I Have a big Problem with my accessXP-application I put a List-object in a Form which is filled with Data from a Tabelle stored on a SQL_Server 2000 Select * from Table The User is able to click an a row and the all fields were displayed in textboxes on the form. and the...- Roschigraz
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
