Access question

[Jcan]

Hi fellows, I have a question...

I am working in Access2000 with a database of over 300000 records. The problem is speed. This database is the slowest thing that ever sat on a pc. In Oracle you can split a table into an index and data separately so that searches are faster. Is there anyway to do the same with Access and also improve the update and search time as well?

Thanks much for all your help

Jcan

 

[SHARKY99]

Split your records in Tables

Sharky99 >:O>

 

[tlbroadbent]

You can't split indexes from the table in the sense you speak of because in Access all objects are in the same physical file except linked tables.

Keep in mind that the database engine runs on the client PC with Access. With Oracle and other server based RDMS, the database engine is on the server. When you do a search in Oracle, the server only returns selected data to the PC. With Access, the PC must find the selected data. If the database resides on a file server, this can be very slow.

You can still do much to optimize queries in Access with proper indexing and selection criteria. Do you have indexes on the search columns of the table? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.