Search results

Solved! Placed GROUP BY clause in 2 MakeTable queries. :)

I am on migration from MS Access 2007 to SQL Server 2012 express. Recently I am faced with strange Access frontend behavor. In one of our Apps based on MS Access I simulate Excel style to enter Employee working hours data on continuous form. On Open event subroutine prepares recordset for this...

Thanks for suggestion but it is already done. I always decompile/repair FE when issue new version of it. The link of application user clicks actualy points to VBScript file and the script makes copy of fresh decompiled accdb file every time user launch the application. So in this way user always...

We have installed ACC2010 runtime one year ago and have not updated it until now. Product ver. 14.0.7006.1000. It is pity to hear that SP does not help to solve it. I am also thinking it is not related to the system design. Each user has own FE copy and all individual copies are on Server. And...

Hi codeslinger, Thanks for reply. After reading article I would say that it not exactly our case but maybe worth to try. Recently one good guy on other forum suggested to check box to "clear cache on close". It is located in Options/Current Database at the bottom. I am testing it right now...

We are running Access 2010 runtime on Server 2008 R2 with both FE and BE on it. Each user has own FE copy on Server which is opened from own PC through remote desktop. After fresh Server restart all goes well for 1-2 weeks. But then some strange behaviour starts: - values of all calculated...