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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by riteshsehgal

  1. riteshsehgal

    Delete Query takes 1 hr to execute even when table contains 10 rows

    i will try that option and see. Hopefully it should resolve. By the way since the number of tables is too large, is there any query that we can run to remove the casacde delete. or do i need to go each relationship and edit it to remove cascade delete. ritesh
  2. riteshsehgal

    Delete Query takes 1 hr to execute even when table contains 10 rows

    Thanks a lot guys.. its because of the cascade delete... But the weird problem is that when we run the programme on the local machine, this cascade delete finishes in 2-3 minutes while on citrix environment it takes 1 hr.. what can be the possible reason? On local machine the database file...
  3. riteshsehgal

    Delete Query takes 1 hr to execute even when table contains 10 rows

    Hi Recently we have migrated an MS Application to Citrix Environment. Following are few lines of code:- 'Begin code DoCmd.DeleteObject acTable, "tblReferenceBusinessUnitRegion" DoCmd.TransferDatabase acLink, "Microsoft Access", strRemoteUpdate & "\" & gblApplicationName & "Data.mdb", acTable...
See more

Part and Inventory Search

Back
Top