Search results

In Access 2003 I was able to create an mde file. I am now using Access 2010, but can't find how I can create an mde. Please help.

Access 2010: Mainform (Table with persons) subform1 (table with course participants) subform2 (Bank book table) In the mainform, I select a person "XX" Next I see in subform1 the courses of 'XX' and the amount due for each course. In subform2, I note the amount received for a particular...

Simple backend table on mysql server: Bankbook (ID, date, IN, OUT) less than 2000 records. Made a simple query in Access, with a selection for the date of the last record. In a form based on that query, I calculate the balance (within the form: = SUM([IN]) - SUM([OUT]); the form takes 40 secs...

Banana, I found several causes of the slow response and I am solving them one by one. e.g. Moved several dB's to front end; redesign of Input forms; alternatieves to calculations of totals in Bankbooks; etc.. Thanks again for the help; I am hopeful that I'll solve the problems Regards, harry

Banana, I understand that the slow response comes from MS Access queries that are not compatible with mysql. If I rewrite the slow queries in mysql, within my frontend Access, could that solve my response problems? Another problem seems to be the combo boxes in forms. Appreciate your answer...

Banana, thanks a lot for yr reply. I understand that actually Access is not fully compatible with odbc backend and that adjustments have to be made at the front end to improve performance. I will try to work my way through the beginner's course, certainly not easy stuff! May come back to you...

Administration program for a non profit organisation, that organizes 125 courses and has 1000 members. Access2003 with backend dB; works fine on a PC. Next year more people in different locations need access to read and write. I converted the Access dB to mysql and put it on a server; and I...