What is the maximum amount of 1:M relationships that you
can have in a database?

How can we make an "AutoNumber" field generate auto-
numbers in a specified
format like for example:
sample-dt-000001

Is it possible to remove a custom input mask from a table?
The problem is there are duplicate identical input masks
that have been created by various people using the same
table, and I want to delete the duplicates.

We are trying to develop a form where users can ask for information
about employee training.  What the managers are asking for is a little
over my head, so hopefully someone can help me.
They want to..

This is new for me.  I want to be able to type an invoice, and have the data in the description, price portion be included in a database of some sort at the same time.  Is there a template or programming code I would use in Access 97 to accomplish this
Rather than tracking ...

With your help!!!  I've designed my first Make Table Query
and there is a field within my Table that has duplicate
records. The duplication appears accross fields.  I tried
to append, but for some reason that did not work. I also

Lets say I have the following tables:
Table Name: "t1"
ActivityID    AssignedTo    Desc
-------------------------------------

I was told not to have spaces in names so I have always put a - between
words. Now while making modules when I input the name of the report or
whatever such as "memo-report-send" the module reformats it as "memo -
report - send". I tried using " around and it did not work is there a ...

Hey all
I'm using Access with some tables linked to a SQL server db. For the most part, I've no problem with the linked table.  However, at certain intervals (say, quarterly), I'm going to "publish" this database into a public network folder so that people can make use of the ...

A slight variation to my earlier post.  Access2000 split db.  I've test out several times and found that Ref Int. holds true in forms built from a single table or a query with a single table.  But if I add in a second table, RefIntegrity is no longer enforced for the form.  It ...

What is a switchboard and why should i use one???

I have an Access 2002 database linked to an Access 97
database running on XP.  Cannot modify a field size in
the 2002 database, when attempting receive the message
cannot save changes the table is linked.  How can I make

I am testing a new application in a multi-user enviroment.
I am getting an error that I did not get when I tested it
on a single-user enviorment.  The error is as follows:
********************************************************

how do i create table?

I'm designing a database with background information about
a group of people. There's large amount of info about each
adding up about 130 variables. There are in fact this many
and I know how to normalize a db.