recently - last week or two, i think - somebody a question about tables or
possibly about trying to secure the database. there were a number of posts
in the thread; and someone explained a way to prevent data entry directly in
a table while still allowing it via a bound form.

I have a need to design a table that contains:
Field1, DateX
Field1 will always be either "A", "B" or "C".  The DateX
will change.  For example, for a known date, ie., January

I need an autonumber field to be incrimented by more than
1. I would like it incrimented by 5 on each new record. I
use the autonumber to give me import order in a invoice
database. If i want to add a row to the invoice i can't

I'm building an Access 2k database to handle Invoices and Receipts, and I
have a question about the design that I'm planning to use.
Here are some of the design specs and business rules:
1. one Receipt can be for many Invoices.

I am using access 2000.
I want to make a database with a data field [File#] to be
have a number automatically assigned -- such as 1000,
1001, 1002, 1003 etc.

I use access 2000. Is there any way to print the design
structure of a table, I don't want a printout of the data
structure ?
by the design of the table I mean need a printout of the

Is there a way programatically establishing which database
a linked table is pointing at?  For example, I have a
front end that can point at a number of back end DBs
depending on what the user selects.  But it would be nice

I have a table which has following fields
Date
OrderNumber
CustomerName

I have a working database and now i have been requested to
add a new field to one of my tables.Ok, but how do i add
that new field to an already developed form?Each time in
the existing form in  design view, i hit the field list,

Hi group,
I have a table with ID's and Names. When I initially
created the table I had all ID's and 75% of the names. Now
I got the list with all names. Is there a way to populate

Got that great double set of Developers Handbooks, but as
much as I know about Access I seem to be missing a lot
between basics and that offered in the Handbooks.  (Some
examples below.)  Is there a consensus on a good Access

I created a combo box on a ZIP Code table within a
Contact Information form.  I used the wizard to set it up
so that when I select a ZIP Code from the combo box
(which displays ZIP Code, City, State from the ZIP Code

I have a form in A2K that contains our customers addresses (linked to Customer table, with CustID as the primary key). Have a subform which contains schedule information, namely a date and time field for when a rep will visit them. This information is kept in a schedule table and ...

I've recently encountered some strange behaviour with
tables in my databases. The databases are Access 97 on
Windows NT 4 sp6. The problem I have is the size of the
tables on the screen when they open. I am forever having

While running this analyzer to tseparate a field into
another table, I get the follow error: