Is there a way to make an access db only open in say access 2002 and
up?

I have an access table
The fields are
    F1 AutoNumber
    F2 text 20 chars long

We have been using Stephen Lebans excellent MouseHook.dll to disable the
mouse wheel on forms in our MSAccess 2002 application.
We have discovered a weakness for which I do not have an answer but
others may benefit from my observations.

I have a field for which I need the data entered to either be in the
form of a date, OR to be "N/A".  How can I write a validation rule (or
is there another option?) to allow for either of these?  Selecting
data type Date/Time does not allow for text but I need both.

Re: Access 2003 / Outlook 2003
In my Access application there are three files that are created,
2 .xls and 1.txt
While I have not integrated Outlook into an Access app,  is there a

Please looking forward to get info about this one: a 2,000 rows Access
table  lately cause underlying queries to freeze (Access Not
responding). So far the only way I found to unlock this is to cut a
bunch of last rows (like 30 or so no matter the number) from the

I have a database that I created that will be used by five seperate
people in my company. Everything else I have created in Access has
been for use by one person. I have never setup a database for a multi
user environment and need some help. Can somebody please explain what

I am a novice to Access, and was wondering if I could get some help on
a problem I can't solve.
I have a database with customer payments, structured like this:
customer code

Again, this is something that I have never done. For my form I have
set the date as the primary key for my record.
I want to create an error message that will pop up and notify the user
that a record for that date has already been created and direct them

I know how to do what this, but seeing as I am old and senile I just
cant recall how right now...
Assume there is a table "tSection" and it has two fields "SectionName"
and "SectionDescription".  I want to have a message box displayed on

I have a table with projects that have a start date, an end date and
total hours, for example:
Project           StartDate            EndDate            Hours
Plumbing        3/16/07                5/3/07                240

Can someone please tell me how to set up the address column show below
so that the Ocean View addresses will sort out in order by street number
BEFORE the Seascape addresses which then should also sort out by street
number?

Hi. I have this Combobox name 'Origin' that contains all states and
countries. I would like to create two Radio buttons (State and
Country) that when you select State, the combobox will query only the
states and vice versa for country. I've create two columns in the

"update [SIM-TAB] set UPDATE-FLAG=false, UPDATE-DT= '10/09/2007
4:09:59 PM'   WHERE ICCID='I1'  "
UPDATE_FLAG is a YES/NO
ICCID is TEXT

Hi need your expert advice.  I want to put my access database online
so different users in my company can use it.  I can put in on a secure
directory on my website.  Can you direct me the best way to do this?
Thanks,