Hi,
I've built a database in Access with frontend and backend db where all users have the frontend on their PC and accessing data which is hosted in the backend on a server computer.
The database task is to generate statistics as charts. That I've realized as reports with an OLE.Graph object. The code to retrieve and assembling the data runs in the frontend db.
Are there anything like "good practice" how to make Access code faster?
Something like prefer queries to sql or viceversa...
I am really lost here and would be very happy if somebody could give me hints even books, etc. where to get more info on this.
Kind regards,
mary.h
P.S. Hope you understand what I mean. I am not a native english speaker as you could guess :-)