I'm looking to create a DB with a person's first, mi and last name and each
person could have from two to six or more locations, phone numbers and
extensions.
Example:

I have 2 tables and I can't make a 1 to many relationship.
Everytime I create a new relationship, access doesn't give the option for
One to Many. I have tried to use enforce ref entegrity and it doesn't change
anything. Table 1 has an AutoNo. for its Primary Key. Table 2 has a ...

I've been trying to design a database that I can use to book
training/conference rooms.  Problem is I'm not sure where to start.  I'm not
a complete novice, but by no means an expert.  It has been sometime since I
last used Access.

I have a database with 48 forms and 15 tables. Only about 10 test data
records in. It has been staying around 8mb for a while as I add coding etc.
I have just added one field to one of the tables and a paragraph of code to
one of the forms to create SQL statement to update the ...

The help as well as the Microsoft website for MS ACCESS lists the syntax:
  CREATE [TEMPORARY] TABLE...
Yet, any attempt to use the "TEMPORARY" keyword leads to a syntax error.
Is this a documentation error that Microsoft has acknowledged - or is this a

i am creating a database to produce help desk tickets. the problem i am
having is that i want to have the date field automatically put in the current
date only when the status of the ticket has been closed. I am at my witts
end!! Any help with this would be greatly appreciated!!! ...

I use an ODBC connection to gather my data but it is too slow.  I have used a
query to make a table instead but I need that data refresh during the night.  
How can I automate this process?

I'm designing a new table to replace an existing table that is populated
with data for the current application.  The old table uses an AutoNumber for
its primary key.  I would like the new table to also use an AutoNumber for
this key.  How can it preserve the existing data in the ...

I want to creat an Access Data base that would start with my parent(s) page
with their page having a drop down list of their children (me and 6 others)
linking to an individual child page of our info, further linking to pages for
our spouse, children and so on for a couple of ...

Background:
I have a database I am rewriting in Access 2000 (split DB) that was
originally written in VB 3.0 with Access 2.0. The database has about 70
tables and was actually designed very well, completely normalized, very

I get the error message below a lot when I do a compact and repair. I use
Access 2002. I have to do a compact and repair a couple more times to get it
to compact and repair correctly. Does anyone know what the problem is?
"Cannot open database...(path).It may not be a database ...

I'm working in Access 2003 but will need to convert this back to Access 97
for some users.
I put this question in Database Design, because I'm all tied up in tables,
forms, subforms and queries, and I'm not sure which one is exactly involved

i have orders which have different requirements, for example
order 1 = requirement1
order 2 = requirement1
              requirement2

Hello,
I am in the middle of designing a database for my department and I need some
guidance as to how to proceed.  I am desiging a form that will be broken down
into 13 seperate sections for users to complete, all sections relate to one

When I open Excel it opens with about a half screen so I have to maximize to
full screen. What do I do to make it open as a full screen to begin with?
Thanks