I am trying to import a table from an AS400 database, but
I keep getting an error stating that there are too many
indexes in the table.  Anyone know a workaround?

I have a access 97 database having more than 450000 rows. Recently I found out that some datas are missing and some data corruption has taken place. No one has tampered with the data. Please advice My email address is sudipta.banerjee@indiatimes.com

I am running Access 2003
I'm trying to set up an Employee database with all pertinent data on each person. The database is not that large in terms of records (less than 90 records)
For each employee I want a pic of that employee
So I set up an OLE Object field in the table to ...

I have the following database structure, for a transportation program
jobs 1:many customer
customers 1:many refferenc
Prb. Every job has one customer. Every customer has many reffernce(employees of the customers). Every job should have also one of the customer's refference on it

While filtering records in an Access Data file, an
unexpected message displayed, "Record is deleted". I did
not click 'OK', but closed the box. All records inthe
database still appeared to be listed. I looked in the

I have a list of companies and a list of analysts who do
research on the companies. The analysts have names
addreesses etc
I have imported two tables from Excel to Access. One is

Hi Guys. I was looking for some advice on the best approach to import table data that was compiled using a laptop into the main database that resides on our server. The dbase was designed to conduct a chemical inventory and then barcode each container. The table “Chemicals” is a ...

Howdy from Oklahoma!!!, I am relatively new to ACCESS and very new to VB so
please be gentle...
Here is my situiation,  I built an extremely large table to contain about 60
'yes/no' fields of an inspection checklist.  I have been told that this was

I have both Access97 and Access2000 installed.  While in
A97 on the tables tab I click the new button then select
Link Table and change the file type to be excel then
select the file.  I then receive this error "The wizard

Can someone direct me to some sample code that:
1) Deletes an existing index,
2) Creates an index
The Northwind example doesn't help much.

The code listed informs me that another telephone exist.
What additional code is necessary to clear the field and
begin reentering another telepnone nember after
selecting "ok" when the error appears?

I have set up a Access database. We have assigned certain
customers to different people in the office.  We have
built reports to show the open receivables by each
person.  When we run the reports we get information for

I had to delete an old table with faulty information and
then create a new table with new information.  With the
old table, I could access my Reports with no problem.  
Now, whenever i go to click on them, they ask me to enter

I have just upgraded to windows XP and Access 2000 now I
can link excel tables.  Has anyone had this issue and do
you know what workarounds exist.

i have a table that has customer's purchase orders along with a yes/no field when a purchase order is marked is closed.  I want that record to export to another table that i named Closed Orders
Help i don't know how to accomplish this.