Search results

I posted this problem some months ago and attracted no replies, so I've tried to explain it better: I distribute sizeable applications in the form of Access 97 .mde files. The problem relates to combo boxes where the bound item is a numeric item queried from a table. Typing a value into the...

Thanks Tay. The ampersand thing has been annoying me for ages!

Solution Solved just as I was on the point of giving up on this one. My wife threw the OLE server message at a search engine and a Microsoft Knowledge Base Article came up! The problem is caused by Norton AntiVirus 2000, 2001 or 2002, and is fixed by disabling script blocking in that program...

Yes, they really are..... :)

Try the following on the click property of the button: Me.RecordSource = "newqueryname"

I would always take the step of creating a query for the combo to work on. This gives more flexibility and may well do the trick... hth

Can't communicate with the OLE server I am completely frustrated by a problem which may be really simple for someone well versed in OLE. I have distributed databases in Access 97 which have forms which contain static images. These graphics were processed via Word and inserted as embedded...

Thanks everyone. And thanks Keith P for the link - I had actually already got to that and was assessing how it might impact on my situation. Anyway the problem - or the main one anyway - appears to be fixed. I was running Office 97 SR-1 and had clearly run into its limitation of 1024 table...

Is it clear which module is missing? From your description of the problem, it sounds as though it may not be the one you think it is....

Thanks for both of the above - the suggestions sound sensible, but i can import all the tables - most of which are linked - without error. I am currently going through the process of importing each set of objects into separate empty databases as a progressive experiment - as yet no real pattern...

I have a fairly large (26Mb) frontend developed in Access 97 which I have been distributing through many versions over the past 4 years. Suddenly it is giving an error at the mde build stage which I would only expect as a runtime error - 'Can't open any more tables'. Curiously, previous...

Thanks everybody for your remarks. It's a big relief just to know I'm not the only one experiencing the problem... The_Doc_Man - I take your point about the FILES statement, and I'm checking it out. I just hadn't thought of that.

Thanks for the responses. IgorB, the problem occurs erratically, so that I don't see how a particular query might be causing it.... Roni, very interested to read your experiences......... I have now checked for unresolved references, but there are none. However, it all helps with the lateral...

Presumably this happens within a bound form........ is it possible you are accessing fields in the bound recordset from code in a module somewhere via DAO instead of through references to the form?

I am experiencing inexplicable 'Out of memory' errors from an Access 97 mde front end on a peer-to-peer network. The backend is located on a user PC, and only the networked front ends give the error. The PCs concerned are running WIN98 SE, and have 256Mb RAM. The error does not seem to be...

Thanks david - that's a great help. Keith

I have users who frequently open multiple iterations of the same application on one workstation. Does anyone know a way of detecting if a particular db is open already? Thanks keith

Hi Is it possible your mods have provided you with non-updateable queries? Have you tried setting Form / Data / Recordset Type to: Dynaset (Inconsistent Updates)? Though be careful that's really what you want.... Regards Keith

I distribute sizeable applications in the form of Access 97 .mde files. I am completely perplexed that combo boxes linked to numeric fields in queries behave differently on different PCs. Direct typing of the required value and Auto Expand will work on one system, and not at all on another...