I have an Access '97 database with a bad table that
crashes Access everytime I try to do anything to it.  
Well, now I just want to delete the table but Access
crashes before it can.  How can I get rid of that table?  

I am about to redesign my departments Database structure.  
Basically we have to many and no one knows who is doing
what.  Also people link from each other and if you (ME) is
trying to code new stuff I get locked out and corrupt my

Is there a way to get an append query to take all paste
errors encountered during its operation and move them to a
table of user(my) specification, rather than the
default "Paste Errors"?

I have a large database (approx 900,000 records) with 95
fields.  When the database was originally created there
was no Header Record, so all the fields are generic
(Field1, Field2, Field3, etc).  I now have the Header

I have just a little question :
How to select a field from a database in an other
database ?
For instance, I would like to use the 3 first column of a

Iam creating a mulitiuser Database where all the users are
entering Data.  I am not able to get the inforamtion
entered to be saved on a common table.\
For example, the Database is loaded on 7 desktops, the 7

Greetings from Canada.
This may sound like a stupid question. Is it possible to
enforce referential integrity between tables stored in
two separate Access MDB files?

I have a 3-tier One-To-Many table structure.
tblOrganization:
OrganizationID (Autonumber)
Organization (Text)

This is a simple question.  Yesterday I needed help with adding date, time and user to a textbox.  Today I am wondering if there is a way to make the info skip a line then add the text instead of adding it directly after the first line.  The code is as follows
Private Sub ...

I want to be able to link tables in Access 2000
using the on load event of my frmLink. The databases
I want to link are on our network on a shared drive (H)
and contain the teams call logs for the day. Each TSE

I have a Vendor Table with 7 fields of company info:
Name, address, City, State, zip...etc Autonumber as PK
It matches up with a Contract Table with Autonumber as PK
I can have many contracts for one Vendor and many Vendors

The SQL Aggregate Functions are listed as Min, Avg and
Max. Does anyone know how to get the medium value?

When using Number as a data type in several columns of a
table, the data is always rounded to the nearest whole
number. I tried changing the formatting to General Number,
but it's still rounding the data.  i've tried to change to

could you please tell me how to go about designing an ER
model for a abc motel?
Thank you.

I am new at creating an Access 2000 database from scratch.  I am
trying to make 3 fields be entered in in caps only.  I have looked at
many of the postings and tried what other people have suggested and I
have not gotten anything to work.  If some one could please help me, I