I need to save my data to a disk
I am using Access 2000
What is the best way to do it
I also need to save it 3 or 4 times a day

I have a table called 'client'. In it is a field called dateclosed. There's
also another one called 'casestatus'. When someone enters a date into the
'dateclosed' field I would like the 'casestatus' field to automatically be
filled in with the 'closed' option which is already in ...

I got an Access DB from our State Controller's Office (SCO) they use to
produce their "Annual Special Districts Report". SCO simply provides the data
in their annual report with very little analysis. I want to analyze districts
comparatively but the SCO table design makes it very ...

In my DB i currently have a junction table: ModelsXREFSuppliers.  It has FKs
to the Models table (Model_ID), SupplyParts table (SupplyPart_ID), and the
Suppliers table (Supplier_ID).  I have just created a new junction table
called temporarily called Windows.  This table contains ...

I have a table in a database, with a text field called "parties-appellant".  
The user may enter one name in the field or they may enter several names,
each separated by a comma.  I've asked the user to use a comma because I use
a Split function in the VBA code that is part of a ...

I have 4 fields on a form that are as follows: [Callers
name],[town],[software], and [comments]. I have two tables involved in my
problem: [Call log] and [town]. What I’m look to accomplish is that when I
select a town in the combo box of the form, it will update the software

I am runing in Access 2003 I am seting the table datasheet name to none when
I come back to the table its falls back to Auto Y dose it fall back to Auto
when I just changed it to None?
Thak You

While creating my database I put a list box in a field, following directions,
however, when I enter records in the database, the only item selectable is
the first field. What did I do wrong?  I see all the choices but cannot
select them.

I have a problem trying to normalize data that has been imported from an
Excel spreadsheet.  I am hoping someone can point me in the right direction.
The sheet has a fuel type column, and a corresponding price per gallon(PPG)
column. There are 10 sets of these columns (Type 1-10 & ...

How do you tell a field that if the date is 21 days past it needs to be "a
color"

Im a command post controller for the US Air Force and I am trying to figure
out a way to use Access to automate a large number of our quick reaction and
emergency notification checklists. Right now our checklists are in word
document format, but I would like them to be in an ...

Hope I'm using my database design terms correctly, and that this make sense.
In a secondary table, I'm using the Lookup Wizard to look up a values in a
primary table.  In the primary table, there is only one field, and that
field is the primary key (i.e, I'm not using AutoNum to ...

There's a bug in Access where the Autonumber reuses old numbers as the
primary key. According to Microsoft, this bug was supposed to be fixed in the
latest Jet version...Not!
Apparently, every time you compact your database, some tables may reuse old

All,
I was wondering if it is possible to set an autonumber field to start with zero instead of one or for that matter any other number other than one?
Thanks in advance. - CES

I have pessimistic locking/edited record.
How do I find out which user has locked a record in a form?