x

problem in access 2007 report

access report pull information (50 fields) from a sql server 2005 db.form has a search field and when i type the search item(already indexed in sql tbl) sometimes it slow.I am the only person playing with the table. Do I need to setup indexes on all the required columns.Will setting up Fillfactor to 70 help.sql table has 6k+ records.
more ▼

asked Jul 27, 2012 at 02:12 PM in Default

neeehar gravatar image

neeehar
80 4 5 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You will need to give us more information to get an accurate answer but with only 6,000 rows then the results should be pretty fast.

There are lots of things that could be contributing factors;
are you using a stored procedure to return the data
are the indexes correct
is the search that is taking a lot of time returning a lot or records
are the statistics on the table up to date

add the table definition to your question and some details on how the data is being retrieved and we can get closer to a solution
more ▼

answered Jul 28, 2012 at 01:45 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 74 78 108

thanks a lot for replying. I created a linked table in access. wrote a query to pull the necessary fields and then created a form.the table structure is similar to an employee table in adventure works db.What I think is its a problem in access not in sql server.
Aug 03, 2012 at 01:21 PM neeehar
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x83

asked: Jul 27, 2012 at 02:12 PM

Seen: 631 times

Last Updated: Aug 03, 2012 at 01:24 PM