Slow Front End Network Runtime Linked to SQL Server

[nrugado]

Help... over the past few days my database has intermittently slowed down. Sometimes it is Fast… sometimes it is slow…

I have a front end that is placed on the network and an icon that is linked to that front end that starts up the database. It links to a SQL server back end through an odbc connection.

I have a question as to when you download the front end mdb to use your own instance on your pc does it requery all of the tables or how exactly does that work. Any insight as to the slowdown would be greatly appreciated.

 

[Onyxpurr]

I have had this problem in the past too. It should'nt pull down the entire table unless you have a query that is forced to. E.G. A grouping by or formatting then criteria on that field.

If you have any queries or reports that are read-only, I would suggest converting them to stored procedures.

For data entry, you should create views with your criteria rather than give the person access to all records.

A book that I purchased that has been a great jelp that you might want to look into is "SQL Server with Access 2000" by Rick Dobson and published by Wrox. It focuses on Access projects (which I don't use) but has a lot of great information on what you have asked and how to build stored procedures. It even has sample code on how to make your stored procedure dynamic with parameters passed from Access.

Good luck!!!

(Another thing too that you might want to look into is using a dsn file for your connection.)