I am trying to relink the tables in a database using
Linked Table Manager from one server to another.  The
systems simply hangs maybe because the link to the
original server is extremely slow.  Does anyone know of a

I'm using the following:
DoCmd.TransferDatabase acImport, "ODBC
Database", "ODBC;DSN=DSNname;SERVER=ServName;UID=userID;PWD
=pass" _ & "DATABASE=DBname",

After I select the linked tables to be updated, select the
source database that conatins the tables, and click
on 'Open', a little dialog box pups up saying "You made an
illegal function call."

i am doing a project for college  and i cannot remember how to insert the
time in my footer can anyone help

I have a database which is a frontend whose data (in
another Access database) has moved to another server and
drive.  I have tried to change the links via Linked Table
Manager but it simply crashes.  I have tried on different

I have a customer that is trying to export Access data to
an in-house VB app.  Here's the scenario.
The data is collected/input on a PC (2K, non-networked) in
Access.  The user is logged in under a special account set

I'm opening merge a Word document from Access.
I can keep the same Query as a source of data for fields in the document
and just replace the body of the query.
Is there a way to change the Query name as the source of data for merging on

I have queries that I need to export into Excel . Is there a way to export
them into pre-formatted Excel Templates instead of always overwriting
existing files?

H-E-L-P!
We just installed Works Suite 2004. I'm trying to export my MSN Address Book
into  MS Word?
Answer I'm getting "I must have MS Exchange "

We have a database that has been converted to 2000 from
97.  The database outputs queries and tables to Excel.  
This has worked correctly in the 97 version.  In 2000 we
get a cannot update; database or object is read only.

I am working on some text files   that I will need to
import to access. However, before I can transfer the data
I will need to filter or clean up the data to leave only
information that I need. In the past, I was able to use

I have 2 buttons on the form in access.
One - Merge and Preview Word document.
Another  - Merge and Print Word document.
Word document linked to the query in the current database.

I would like to send a copy of an existing database to
someone, but without all the data in it.  So I want the
format of all my tables, forms, reports, etc. to go, but I
don't want any of the data to be included.  Is there a way

I have acquired the wonderful task of redesigning a database that has been in
use for about 3 years. The person who designed the database did not normalize
the data, so I have one table with several columns that all represent the
same type of data (imagine a student schedule with ...

I am trying to import several seperate Paradox tables into
access and append all the tables into one table.  There
are 35 seperate paradox files with 1 table in each file
and all are the exact same table structure.  I want to