I want a simple Access app (must be built in Access not VB) to look at a SQL server database. How do I go about this making sure that it is very fast and reliable (have been told ODBC is slow)
This is wthat needs to do be included:
Get the user to enter a few parameters then display some reports based on queries (i'm fine with that). I have written the quiries in standard format but this ends up being very slow and a large amount of data is involved.
Some of the quiries convert text into dates and also use counters, sum and average functions. Each user can have there own copy on there PC.
If you have any ideas that would be great but please keep the instructions simple.
Ta
This is wthat needs to do be included:
Get the user to enter a few parameters then display some reports based on queries (i'm fine with that). I have written the quiries in standard format but this ends up being very slow and a large amount of data is involved.
Some of the quiries convert text into dates and also use counters, sum and average functions. Each user can have there own copy on there PC.
If you have any ideas that would be great but please keep the instructions simple.
Ta
