Is there any way that I can disallow users from importing
tables from my database into their own database. I have
it split into Data and Application databases, but I have
noticed that a user has imported the tables from the data

I have a mailing database that has one table with customer info, and one table with store info on.  The tables are linked through a store no. which means that i can view a store and find all the customers related to that store. Each customer record has a tick box to say whether ...

Ok, here is the problem that I am having which I hope someone can help me
out with. I am using ms xcel 97 and ms access 97. What I would like is a .db
file where I just can enter the date time and a value and that it will go
automatically to my spreadsheet and if I change a value it ...

By default, when a table is printed, Access prints a
header, showing the table name and date. This can be
deleted via page setup, but is there a way to edit the
header? Many thanks.

I have two tables: EMPLOYEES and DEPARTMENTS
Departments has only two fields: department numbers and
department names.
I want to have two fields in the Employees table - one

I have a existing table with data.   I want to add a new
field to this table with an default value.  When I add the
new field, the value of this field in the existing records
is not the default value it is blank.   How can I easily

I'm new to Access and am very happy and satisfied to find
this users group.  Someone out there please edumacate me.  
From reading various posts here it seems that using
datasheets for data entry is a NO NO.  Why is that?

I would like to know you could setup a Switchboard where
only that is showing, and users have no access to tables,
forms, etc.  So if you have a shortcut on your desktop it
would take just to the Switchboard where I have just

I'm designing a db that has 'initiative' as the main
table, with a 1-many for 'phases', with a 1-many
for 'goals', 1-many for 'objectives' and 'milestones'.  
So, my initiative, say Health, has four phases (like

Access 2002 SP3
When attempting to import from either an Excel spreadsheet or a CSV file the
wizard fails to function properly.  Everything works fine except the part
where I tell the wizard which columns (fields) to import.  The first column

Is there a way of sorting the days of the week in their
normal order?  If they were sorted alphanumerically they
would come up in the wrong order.  Iwant them to start on
Monday or Sunday and then display in normal order.

I split my database and realized that I needed a new field
on my table/form.  I am able to enter a new field into the
back end table, but it does not show up on my front end
table or in my front end form Field List.  How do I add

I ran an corrupted mdb through a third-party recovery utility and it
recovered the tables but it changed the AutoNumber fields to Longs, all 200
of them. Since the tables have data in them I can't simply change the field
type back to AutoNumber, at least not in the Access table ...

I have created several groups in my mdb as I was
developing it.  Now that development in nearly done, I
would like to resequence the groups so that they are more
structured for the end-user.  (They could refer to the

I need to create a field in a table to store a date like
January 2004, February 2004, March 2004 (or 1/2004,
2/2004, etc). Each month we will enter in some stats for
the month and ultimately my goal will be to do some