Query in Acess or SQL?

[abhi.karnawat]

hey,

my database is located on a MS SQL2005 server, and i use MsAccess2007 as front end for the database..
i have over 3000 records on them and growing every day..
Now i have linked the tables in MS access but am running all my queries in MS access.. which sometimes take a while to display the data.. i want to know if i put all my queries in SQL database and called on them from access front end would it speed up things rather than querying in ms access?

regards,
abhi

 

[Galaxiom]

3000 records is a small table so any query should be quite fast.

Maybe you have a network issue delaying the connection.
Maintain a continuous connection.

Optimise the record source queries of any forms so they only return the records you need.
Index any fields in the tables that are used in the query criteria.

I have a table with four million records in a table and Access displays my results in under a second.

 

[abhi.karnawat]

would u be able to analyse my application if i sent it to u ..i will include the odbc connection username and pass.. ?

there are certain issues i would like to go through one by one.. from the sql database till the front end app.. so that i can make this application fast and reliable for the future..

and i would really appreciate the help. thx

regards, abhi