Search results

Yes, the table is linked from the FE to the BE

Correct I have a user in the BE with the table open. When I try to replace the table in the FE by the Make Table Query I get the error. The columns are always the same, so I will try your suggestion and run a delete query and the an append query in the FE.

The error message is: Could not lock 'tablename'; currently in use by usere 'UserName' on machine ''

Thanks for reply. I get to work in about 3 hours time and will report error message then. Many thanks

I have a Front End Database and a Back End Database. Certain tables in the BE are linked to the FE. Once or twice a day I need to run Make Table Queries in the FE, but I am unable to do so if someone else has the BE open. Best solution would be greatly appreciated Many thanks John

John K, Many thanks. Worked a treat.

All, I have 7 unbound calculated fields in the footer section of a subform. [Text1], [Text2] etc. Does a VBA guru have a bespoke function which will calculate the maximum of these fields in the same subform? Any help greatly appreciated. John

Table Fields I too have found Candace's examples very useful, however the example usese a table with: RowField = Text ColumnField = Text NumericField = Number I need to have the RowField = Date/Time but I can't get it to work. Any help greatly appreciated. John

Hi, I need a report that produces what skills are available to a department each week. As can be seen from the attached file for W/C 5/09 there are 3 people all with the skills, Counter Bal, Problem Pal & Reach Truck. The Field Min_No denotes the number of staff required for that skill and...