I have just inherited a Access97 database with lots and lots of tables and
relationships and forms and queries and well you get the idea. They want to
step away from the 97 and goto to 2000 (for the life of me don't ask why, I
have been asking the same thing, why not go to 2003 ...

I have a text file I need to import into Access 2002. It is not delimited
however I know the char length for each field. Is there a way I can import
mutliple records into a table with predefined field sizes (e.g. Field 1 - 10
chars, Field 2 - 3 chars, Field 3 - 1 char etc up to ...

I'm trying to export an Access query to Excel to make a complicated graph
that access is not able to create, then Import that graph to be included in
an Access Report.  Is this possible to do?  The version I'm using at work is
Access 2000 (unfortunately).

I have revoked all permissions on the backend files and am using RWOP queries.
All of a sudden I'm having troubl linking to my backend tables at startup.
I'm using the following
routine to accomplish the linking.  

I have a MS Access as the front end, and create several linked table to SQL
Server views through ODBC. I thought by using the views on SQL Server, the
Access front end will have read only rights (that's what I want). However,
the Access front end has all the rights (insert, ...

When trying to crate an OLAP CUBE from an access database in excel, i get the
following error. Does anyone know how to fix this?
CLIENT SAFETY OPTIONS DO NOT ALLOW PAS THROUGH STATMENTS TO BE ISSUES TO THE
DATA SOURCE

Is there any way to import a file with the file extension of UNV? This is
Business Object Universe file that I would like to import into an Access
database.
Thank You

I linked a table to my database, but the the date field in the table does not
match the the data type I use in my database. I can not change the data type
in the linked table because it will effect other databases. So I tried
copying the link and then tried to change to data type ...

When I publish an Access report to Word, often the last word or few words is
left off. There is no consistency with regard to the size of the selection.
Has anyone else experienced this problem and if so can it be fixed?

I'm needing to import a Visual Fox Pro Table into Access. I'm using ODBC.
The table itself is about 775 MB with around 1.7 million records.
When I import it....it will appear to be going through the process (about 3-5
minutes will pass).  Then, an error will occur.

I cannot import a tect file into my access database.  The alert from the
Improt text Wizard says "property not found".  What could be the cause of
this?

I have a Table in a Database that has two rows "updated" and "Cancel" both
are Yes/No fields. I have my data in an Excel spreadsheet and the columns
"updated" and "Cancel" are either a Yes or a No (when I right click on those
columns in Excel I have formatted the columns to be ...

How can I merge an Access Database table into a Word document.
Thank
Ileana

I have a button on my form that runs a transfer spreadsheet macro to uplink
data from excell into a access table.  Question:  is there a way to prevent
the data to be uplinked again??  Right now, if a user press the button again,
the data is uplinked again.  Now, duplicate data is ...

Strange that when I use get external data import function ( importing
CSV file), in the import text wizard after selecting the following
delimeted, coma, first row contains field names, store in a new tabl
option, in the window where you can choose the field option, only th