Index Concept in MS Access

R

Ravindhar reddy

dear sir/madam,

is there any temparory table concept(run time) and
index concept like in SQL .if these two concept are there
please send me the help regarding that


regards
ravindhar
 
J

Joe Fallon

You can build queries on the fly in code so you can consider them to be the
equivalent of temp tables.
Access supports 32 indexes per table.
I rarely use more than 3 or 4.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compound Index not Preventing Dup's (?) 4
page layout and print layout differs 1
How To - SQL Server? 3
main form / sub form concept (again) 8
Calling Access 'form' from other applications 0
Menu Ideas in Access 2010 0
Sending personalized bulkmails 4
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top