access-2007

how to receive fast result from access query ?

hi i have table (MyTbl) that has 3 field's A,B,C this table contain 800000 records. what is the best way to receive fast result ? i try this: select top 1 A from MyTbl where A='123' but it isn't fast i work with Access 2007 - and C# program ...

how to force null in date field - access 2007 ?

hi i have table that contain date field. how i can force null or empty value on this field ? thank's in advance ...

Table/Form design; Record/user has Multiple addresses, selected the address that is the contact

Hi there, Looking for advice as to the correct method of solving this design issue I have a table for a profile / record (tblProfile), each profile can have more than one address / property (tblProp) I have a form for adding a profile, and a seperate form to add an address. What would be the correct method for allowing the selection o...

VBA photo/image compression

Hi there, I am wondering if this is possible and within the realms of Access? I currently have a database system where the user can open up directories/folders related to the record; such as images, docs etc... This avoids bloat by attaching the images to the records and what not, and works fine. A user enhancement would be to allow th...