Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slow table access....

Status
Not open for further replies.
JennyPeters

JennyPeters

Programmer
Oct 29, 2001
228
US
Hi,

I have a table that has 17,000+ records in it and it's really slow when I'm accessing it. There is an index on the rowguide column, but I'm thinking this is one of the reasons why it is so slow. I never use the rowguide for accessing records, just numeric fields within the table.

Should I remove the index on the rowguide?

Jenny
 
Status
Not open for further replies.

Similar threads

scamquist58
  • Locked
  • Question
VB Change Default Printer - Access
Replies
1
Views
334
combo
combo
breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
374
breezett93
breezett93
dw134
  • Locked
  • Question
First Attempt SQL Backend and MS Access Front End
Replies
0
Views
334
dw134
dw134
LittleNick
  • Locked
  • Question
Can Quick Access Toolbar be disabled in Access 2010?
Replies
0
Views
345
LittleNick
LittleNick
InspectorHound
  • Locked
  • Question
Creating an MS Access 2013 project with multiple forms
Replies
1
Views
371
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top