I work for a flower export company. Our entire production
is run
on an Access 2000 Database. 10 Users with a front-end on
their PCs

Does anyone know of a good source for sample databases?  I
am looking for an H.R. Skills db.

I need to set up a simple table in which I am keeping
track of height and weight out to 2 decimal places.  What
do I fill in design view after selecting number as the
Data type?

Hello, I have a table that is written to only by the
after_update feature from a form field. This form is not
tied to the table. How do I keep users from writing to
this table either directly or in a query result?

I'm interested in hearing the opinions of people who use (or choose not to
use) combination keys in their table structure.  What do you think the
advantages and disadvantages of using combination keys are?  
If I were to have these tables:

I have a comma delimited file that has 900 fields.  I
understand that Access has a 250 field limit.  Is there a
solution for this problem or do I have to look for a
different database software?  Thanks!

Group
   I have a piece of software that allows me to use a ODBC service to
authenticate users. I get a invalid user id and password. They are very
specific in the layout of the table as one would expect. Below is the format

I am wondering about proper or accepted practise for ID'ing records in a relational database.
My question is this...
If I have a table with a unique feature should I still use an ID column?
Example 1:  (Note: SSN = Social Security Number - assumed unique to every person)

I want to creat a dialy planner for clients. How can creat it in microsoft
access to book/cancel/change the appointments & appointment times.

Hi, if you use the date() function as a default value in a
table, does it automatically update when you open the
table or actually modify a record?  Is there a way to have
the creation date as the value, or a modification date

I have a database in '97 format.
I want to upgrade it safely into 2000 format.
I used the command:
tools>database utilities>convert database

I am creating a database for volunteers from all over the World.
I want to set up a table to use in a combo box of the standard list of
countries you get in any web site that asks for your country.
I don't want to have to create the list for myself. First because it will

I've got a prototype database that handles pay surveys. Data is entered by
organisation and is reported by job level, quartile, average, etc.. The
statistical element is quite complex so has over a hundred queries, many of
which form unions.

I have a table with an autonumber that I need to start
with the number 20801.
Access help says to change the New Values property.
I don't see that property listed anywhere.

Hello! I am close to finishing the forms to my database but still trying to
wriggle out the little glitches. I have a main form that is mostly used to
view data, and the user is then given the option to update the data in this
form by clicking a command button that takes them to ...