Is there a fast way to recreate the structure of a database without the data?
I would like to use the design but not the data...
Thanks!
Cheese

I'm trying to figure out which would be the better design for a table or two.
I'm converting paper forms into a db format.  On the paper forms, there are
categories for Current Land Use (Ag, Commercial, Residential, etc) and
Disturbance (Logged, Erosion, etc).  Each of these have ...

I am adding records to tblEmployees using below, no connection:
strAddRecord="INSERT INTO tblEmployees() VALUES ()"
DoCmd.RunSQL strAddRecord
and this works fine. I then open the same table, over connection:

The following tables were generated by my data base, what cuase it?
MSYsAcceStorage, MSysACEs, MSysNavPaneGroupCategory, and a few more with
similar name.
Did I do something wrong or something cause this that I don't remebr?

I have a database where I want to have the lookup fields cascade. A good
example of this is when you visit an automotive parts website. You first
enter the year of your vehicle, then the next field (Vehicle Make) lists
vehicles from that year, then the next field (Vehicle model) ...

Is there any code or thing that can transfer a report to pdf file?
many thanks

I have read some explanantions about many to many table relationship, but it
is not so clear to me in practice.
My church membership database that I am going to make will include list of
church officers or servents we can say.

I have a table for OT(primary Key is ID  that auto numbers) that the employee
goes in to a form and enter in the hours they are available to work for the
week and that does create a good record.  The problem I am having is that if
the employee goes back in to make a change a new ...

I have 2 tables that have coorsponding data that are gathered in time.  In
table A the time is (EX. 12:34:17pm) in table B the time is calculated every
6 minutes for the required data (EX 12:30:00pm  next  12:36:00pm)  
The Question:  how do I querry the two tables so that when I ...

I have 12 locations, 4 security checks, and 16 different security check
times.  They want to put in a db a months worth of random checks (so they can
see ahead at when they will do them), performed 3 per day, and sign off that
it was completed.  IE, day 1 has location A doing ...

I have an in-house developed control room program receiving data from
different sources & I want to also receive data via a RS 232 port  from a
radio transmitter. Help

I have two forms linked as tables by a one-to-many relationship.
This is what I need. A control on the "one" form which opens the "many" form
but which filters records within the "many" form using the primary key in the
"one" form.

I would like your opinion on this; I have a ms access database that will be
used in a multi-user environment, across different Teams. Data will be loaded
from text files several times a day in a MS Access table, users will retrieve
the data from the tables and displayed in a form. ...

I have a client who wishes to place several hundred documents into a
database. Then attach values to specific statements in the document. So far
so good.
But, the documents are inconsistent in their presentation the statements for

I am working on a database that, among other things, will be used to
record Chemistry Lab Values (it's for Cancer Treatment).
The structure of the table is like this:
CREATE TABLE PatientLabs(