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
...
hi
i have table that contain date field.
how i can force null or empty value on this field ?
thank's in advance
...
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...
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...