Is it possible to open two databases, to view them
simulataneously, for the purpose of copying records back
and forth?

I'm a relative beginner with Access.  This question is quite similar to another I found here but with an important difference.  I am trying to create a single database from 2 excell documents.  There are more columns in one document than the other, some of them being common with ...

I have table in a sql2000 database which I am attempting
to link using access2000.  It appears that any of my sql
tables with an  '_'(underscore) in an index related to
them cannot be linked.  Tables which dont have any

Can anyone suggest how I might be able to "pack" a linked DBIII file from
within access. I am using access to build the data needed for a  label
printer (it can only read DBIII) and currently have to open the  printer
utility to pack the database to remove the deleted records. I ...

I have a numeric field that needs to be formatted as six
decimal places long. I have tried defining the field size
to both single and double.  However, when I export the
table (tab delimited text file) using the export wizard,

For what it's worth
I was having trouble getting Access 2002(10.6501.6626) SP3 to update a table linked from Excel (same version)
I whittled down the problem to the following scenario
1. Create a new blank Access databas

From Excel, I create a new mdb (named as the active
excel workbook) and a new table (named as the
activesheet). With the connection open, I call this sub:
Public Sub ImportSpreadsheet(strTable As String, _

In merging a word doc with my database, the field
containing a dollar amount populates the word doc field
in a fixed format. The database design: filed= number,
format long integer, currancy, auto decimalplace. Please

When I export a numeric field for example 8.275  to a
external txt file the resulting field in the txt file
shows only 8.27  .    The field is defined as having 3
decimal positions.  Why does it drop or truncate the third

I was able to import or export from Accessm to Excel.
Recently someone tried to fix something on my PC, after
that I lost this capability; i.e. when I try to import an
external file (from Access), on the file type dialog drop

Hi, How can I capture a list of URL's from excel into a table in Access ???
I have a table with a field of type Hyperlink... however, when I map the data from excel it displays as a hyperlink field, but, there is no address associated with it when I attempt to edit it from the ...

Is there a program that will convert a large complicated crosslinked excel data sheets into a Access program. The program works well in Excel but I have a need for speed.

Hi, all
In past, when have I old PC under W98 - I link in Access2000 without
problem FoxPro table with or without MEMO field. I select dbIV -
filetype.