Search results

sorry that sounded a bit like a rant, I guess it was a bit as this is really frustrating me and I've read about 100 things along the lines of those suggestions trying to google this issue. I did actually read the "ovbious suggestions" even though most of them were from about 1997 or were just...

I'm not sure what I am having trouble explaining, My database is not slow when accessed by a single user!!! It is only an issue when additional users try to use it simultaneously (this is easy reproducible) There's ovbiously some bug, probably related to MS server/LDB file access which is...

It's set to compact on close, I just don't understand what changes when other users already have the BE open :(

Sorry I meant which bit of options Curret database doesn't seem to have much about locking? Client settings is "Default Record Locking" - "No Locks"? Most of my users are on access runtime (the PC i've been holding it open with to test is on Runtime)

sorry, where in options? (that does sound like the kind of thing it might be) also FE or BE? or both?

It would if it always took 20 seconds to walk to the Locksmith, but it doesn't! Why's there such a performance hit with more than 1 user in? (an LCK file present) Edit: And if once you had made a 20 second trip to the locksmith on a "bad" day, that if you had to go back it still took 20...

Making the links seems to take about 20 seconds before the dlookups add on - (this is why I said 30 seconds in my first post) I dont really see why making the links after the DB opens would take longer than the DB having to make the links as it loads? Edit: for comparison, with no other users...

each user has their own local FE (accde) I publish updates to a server location from my development accdb (the FE checks for updates and fires another accde to overwrite their local copy with a new one if applicable)

P.S. I think "slow" is a fair bit faster on my PC than others, Anyway, a bit of commenting out shows its mostly the two Dlookups that are slow when a second user is in, why is this? To clarify, over the network, single user, the dlookups are instant (as the tables searched are tiny [sub 100...

There's nothing occurring before the form loads that takes any time at all when a single user opens the FE (I've just inserted some timers and a message box - the MSACCESS application takes longer to load than the form [and code before it]) however as soon as one user has it open on another...

I've just disabled the deleting of links, so the 3 initial tables "stay" linked when the program is closed and dont get relinked on open as they are already linked, The same behavior occurs, opening takes a very long time :(

:( those are all rather generic suggestions of rather obvious stuff. I've had to restructure a few queries to avoid the "Having" bit of SQL but overall it works very quickly. Apart from certain times when multiple users are in, I've read some comments about this being related to the Locks...

I have a mostly typical FE/BE split, however: My FE opens with no tables linked by default and links are made on the fly depending which BE/ODBC datasource will be needed, I always start with links to one primary BE "Admin" table where odbc info, user info, version info etc is listed (I link to...

ODBC Without "select unique record identifier", FoxPro DSN-Less, Easy Late Binding So I've been looking into the following: Trying to Link to tables through ODBC using "DSN-Less" methods (without having to add a system DSN) gives Run-Time Error '3000': Reserved error (-7778); There is no...

Me! :Master table on Main form with primary key (creatively called ID) set as the Link Master Fields, Link Child Fields set to a field in the subform's control source (which is defined in the database relationships with referential integrity enforced to ID) when I add the first new record via...

I've used functions to pass form fields to queries etc and do a bit of formatting etc on the way, didn't really realise what it was i was doing at the time! will the cursors on the recordsets stay where they are when they are passed to the subs? (i'm using Loop - MoveNext to progress down a list)

Hehe, good point about the 9's, hadn't thought about it that way :) And yea, doing the diagram really helped me understand the layout for nesting/what I can copypaste/what i can put in a sub without going near any Goto's :) Ohh, i'd not seen the byref thing before, I have 6 recordsets tho :/...

See Attachements .PNG is the messy tree again (I renumbered 1-9 and put T/F on the lines and a basic logic statement for me to refer to as well) [there are functions peformed after each T/F that change the value of "dem" etc] .JPG is kinda how I'd picture it with nested If's Edit: small fail...

Hehe, wondered if that might be the response :) How do I jump to a later sub? Also will the RecordSets I open in the main function still be open for the subs to work on? Also will I get a ton of "variable not defined" errors for the subs?

Would I be better off doing this with GoTo statements? (I know these are frowned upon but I guess they are fast processing wise and save a lot of repetition?)