Search results

  1. I

    Access 2010 - simple update query gives "Operation must use an updateable query"

    Re: Access 2010 - simple update query gives "Operation must use an updateable query" They aren't, why is this a requirement?
  2. I

    Access 2010 - simple update query gives "Operation must use an updateable query"

    Access 2010 - simple update query gives "Operation must use an updateable query" UPDATE PrioStaff INNER JOIN wname ON PrioStaff.wn_ref = wname.wn_ref SET PrioStaff.wn_lvr = [wname].[wn_lvr]; Both are tables, why on earth doesn't this work?!? (I started with something more complex and kept...
  3. I

    multi level query with sum queries etc (slow/repeating)

    I've got a number of tables which I'm combining into a report by "Part", However due to the layout of the tables (for example, Stock or Orders - having the same part multiple times in different places) I have to group and sum these with their own Totals query before I can combine them otherwise...
  4. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Some Feedback: The above worked a treat, performance is "almost" instant, probably 2-3 seconds, so 10 times quicker, I've not had any time to tweak code but I plan to put in a kind of Prefetch form that does the previously mentioned persistent links to tables when the database first opens...
  5. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    I wish I could explain this better somehow, the performance when already open is not the problem, its the performance when first opening the whole database, and infact MS Access, that is the problem for us, how does a persistent link help that? surely it can't persist when MS Access is closed...
  6. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Compare that Wireshark to our 2003 server to this from a Win7 machine running SMB2 2776 8.050954 10.0.0.42 10.0.0.40 SMB2 GetInfo Request FILE_INFO/SMB2_FILE_EA_INFO File: test\testBE.laccdb 2777 8.051246 10.0.0.40 10.0.0.42 SMB2 GetInfo Response 2778 8.051308...
  7. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    WireShark traces from a test DB called testfe/be, with one table called "table1" with about 20 rows in. 482 3.858198 10.0.0.42 10.0.0.10 SMB NT Create AndX Request, FID: 0xc29c, Path: \Stuff\TEST\testBE.laccdb 483 3.858631 10.0.0.10 10.0.0.42 SMB NT Create AndX...
  8. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Sorry to keep going over this but i still do not see how the persistent connection idea applies to my problem?
  9. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    This works... in as much as the error only appears once and causes a 1 second slowdown per BE, I guess its a solution but I'm not that happy with it?
  10. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    The timeout sounds very interesting, will give that a look tomorrow. Yep, remoted in to check just before I posted, Definitely disabled Haha, as a master of the old "off and on" I can see where you are coming from, The server was rebooted friday so we will see if there has been any change...
  11. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Yes the server has had OpLocks disabled for a year at least I will try diabling it on a client and monitor the result would you like a more complete wireshark trace? (is there a length limit on posts here?
  12. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters\EnableOplocks" already = 0 We changed this setting a year or two ago when troubleshooting another issue. From what I understand we do not need to change the settings on the clients as this setting on the server will...
  13. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    I dunno exactly what " file-share declaration " means but I assume its the Shared folder? this?:
  14. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Yes, I do have Jet BEs, I didn't do the automated split, if there is one, I've just created 3 ACCDBs to store tables all my users's local FEs access I've just logged in to check, ALL folders have Everyone set to full access in the Security Tab, on the Permissions of the Shared folder the...
  15. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Thank you! :-D
  16. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    Server 2003 32bit I'm connecting from a win7 64bit
  17. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    No, sorry to have added complexity mentioning FoxPro, none of the "housekeeping" or primary stuff goes near foxpro, foxpro only gets involved with some reports right at the very end, I'm having problems with the pure MS Access startup bit. just logged on to check, Everyone does have Full...
  18. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    sorry, "1 SQL Insert:" is just a docmd.runsql :) I've only got ACCDB back ends at the moment (and I link to FoxPro through ODBC, but that works "ok" considering)
  19. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    having done a bit of testing, basically with the effect you use in: Refresh Links/Relink Module with a *Persistent Connected* form If I open one table from each BE, I get 2 of those 1 second SMB errors, per BE, but thats it, after a non specific delay I can then open as many tables as I like...
  20. I

    Question Split Database sometimes VERY slow (more than 1 user?)

    i got annoyed and turned to Wireshark and I've basically found the culprit: this is with: no "relinking" so i'm leaving the links there [not going to the lock smith every trip home] compact on close is disabled autocorrect tracking is disabled "no locks" is set so just performing 2 Dlookups...
Back
Top Bottom