Recent content by pondlife

We have an accdb database developed in Acc2010 on an XP PC. On a new Win7 PC with Acc2010 the database worked fine for UserA, but UserB on the same PC got the error: Function is not available in expressions in query expression "Ucase([MyField])..." (Ucase() is the only function in the query...

Thanks Dave. What we are seeing in the back-end lock file (after every client has logged off) is effectively a persisting list of all 5 clients. We suspect that this is not caused by the usual culprits (such as your helpful list of crashes/failure to close access before power-off/killing...

You're quite right, this slowness only seems to happen for some forms/subforms and some databases (small or large; mine are always split). Note that affected forms/subforms themselves can work perfectly in use - not slow at all. But my overall point (like gunslingor and pr2-eugin) is that...

... and as each user closes their front-end, their entry is removed from the lockfile of the back-end. That's not happening in my case. I'd like it to happen (so in order to run a compact/repair on the back-end I don't have to get in 30mins earlier than everyone else to reboot the server to be...

This is the bane of my life. Open in design view a form that has a subform. click on the subform a minute or three passes before the subform is selected and active by this time I've forgotten what I wanted to do with it. click on the main form again remember what I wanted to change on the...

Thanks Pat, very helpful. I hadn't noticed the ULS changes. I'm suspicious that all my users are creating permanent lockfile entries. I'll keep a watch on that. What are the usual culprits?

We have a split ACC2010 database, with the back end on our server and 5 front ends on 5 client PCs. I hadn't run a compact/repair on the back end for months. When today I tried, I got the 'database is locked' error. The lock file showed 'Admin' logged on at all 5 clients. The front-ends had been...

I've followed How To Create a Shortcut Menu for a Form... to create a shortcut menu bar. At the moment my shortcut menu just has buttons, e.g.: cmbRightClick.Controls.Add msoControlButton, 21, , , True Now I'd like to add the advanced filter menu (FilterAdvancedMenu) to cmbRightClick...

Thanks Pat. Understood (though I had to look up 'SOL'). I'll contact MS Support and report back here if anything useful transpires. Incidentally, the KB928023 article is clear that it has to be the field projected into the query from the one table that, if complex, causes the trouble. (ie the...

Except that we have many pricelists for the same products (different suppliers, different circumstances). What's concerning is not the underlying reasons for the design we have but the surprising behaviour that the design produces. KB928023 describes the same surprising behaviour in the...

The main form 'one' table is a pricelist, the 'many' table is the prices in the pricelist, and the second 'one' table is the products whose prices feature in the pricelist. Products have a type that we need to filter by. Does that help clarify?

Overall we have a one-many-one relationship. The first 'one' table is the recordsource of the main form, the many-one query that is giving the problem is the recordsource of a (continuous form) subform.

Thanks Pat. Although the One table contains several fields with complex data types, these are not used in the join or the field projected from the One table. Both those are Long Integers. (Incidentally, is there a definition anywhere of which data types are counted as 'complex' data types?)

We have tried inconsistent updates, but the results were unpredictable.

Thanks for your reply Bob. This is a development project so I'm told I can't provide screenshots, sorry. The query is of this form: SELECT tblMany.ManyID, tblMany.[OtherFields], tblMany.OneID, tblOne.TypeID FROM tblOne INNER JOIN tblMany ON tblOne.OneID = tblMany.OneID; We need both tables so...