I have made a database devided into a back-end and a front-
end. The back-end is installed in the shared folder on the
network and the front-end databases are installed on
users' machines. Both back-end and fron-end are .mdb-files.

I am using Excel XP to import a single sheet to Access
XP.  Every single time I get this error:
"The wizard is unable to access information in the
file '<pathname>'. Please check that the file exists and

I need some direction here...
I am in the process of developing an Access database that could potentially
contain over 100,000 records, maybe more.  This application will strictly be
a read-only database for reporting purposes, not for adding/editing or

Can a table be imported from Word into Access

Is it possible to print the formula in an excel linked
table (e.g.  b$1 / c$1) from the linked table in access so
that I can show the formula used from an Access report.

I am trying to import from an Excel file into an existing
table.
The first row of the excel file has the column headers
exactly the same as the field names in the table.  Most of

Is there any limit on how many objects the
TransferDatabase Action can handle?  I am trying to
import more than 700 reports from one database to
another.  The docmd.TransferDatabase run fine with the

I'm a middling Access user and have come across what I
consider to be a real stumper.
We have one category of contacts in Outlook that we would
like to use as part of an Access 2002 database. It is

Could someone please tell me how to save a database to a
CD (it's too big for a floppy)? I know this is probably
easy, but I can't seem to figure it out! I need to save
it so that I can send it to someone, have that person add

I wanted to know if it is possible for access to use data
contained in the fields of my database to do a search on
specific website then import the results into another
field.

I just upgraded a user to Office 2002. Since the upgrade
she has to re-link her tables every time she opens access
and tries to run a query. If she doesn't she gets
an "ODBC connection failed" error until the re-link. As

I'm replacing (or trying to) an ACT! 2000 set up with a
MSAccess app.  I have successfully imported and linked all
the tables but one, and I'm spinning my wheels with it.  
One of the ACT! "tabs" appears to write to a text file or

I can't seem to import data from Excel to Access, due to
the filetype not being there on the drop down menu, when
selecting the import option.
It used to be there, but since I reinstalled Office, the

I am trying to update a field in an access table based on
certain criteria.  What I need to do is update a
description field with the appropriate text from other
tables based on the part number field.  I have the sql

I run acces 97.. everything went ok until 3 days ago when
I installed Windows 2K sp4... since then when I try to
export a table to excel.. let's say to my
server/folder/subfolder/example.xls I get the 3027 error