Good morning all - I am converting several databases from
Access 97 to Access 2000.   The smaller databases are
working fine. However, I have a number of large databases
that I have converted - queries on large tables in these

I have been trying to read the works 4.0 files I have
loaded from my old computer into my new computer with Ms
Office. The files have transfered OK but come out as
gobbledygook when I try to read them in MS office and the

I want to import my database table into the
sample "Contacts" table.
When I open Contacts db and open the Contacts table and
then use Get External Data it creates a new table for my

I have two files, 62 MB and 82 MB, that when I try to
convert from 2000 to 97 I get an error message "record is
too large."  Even after compressing to become 17 MB and 36
MB, I get the same message.  These databases are made up

I installed SP 8 per the directions at ACC2K3 startup.  Rebooted the
machine.  Opened my MDB, and was presented with the same prompt.
Any ideas?

Is there any way to calculate the natural log (LN() in
excel) of a number using VBA within Access?  I can do Log
() but I can't fine LN().
thanks

I have a frontend backend for a user who runs Windows
2000. The backend is on a server. The frontend is on a
workstation that formerly had Windows 2000 with Office
2000. After the user installed Office XP (without

Any idea how to get an Access 2.0 .mdb file converted to
Access 2002?  I just bought Office Pro with Access 2000
and it does not have a converter for this old file.  The
Office website says that no converter is currenty

Does anyone know where there is some Access VBA code that
will scan a table in MS Access, (looking at all fields)
and output a CREATE TABLE statement that could be used to
create a "clone" of the table in SQL Server.

Has this function been removed in Access 2002, Service
Pack 7? Is anyone using it in Service Pack 7?

OE REMOVED ACCESS TO THE FOLLOWING UNSAFE ATTACHMENTS IN
YOU MAIL; I KEEP GETTING THIS MESSAGE WHEN ATTACHMENTS ARE
INCLUDED. IT CAN BE A .HTM OR .IPG IT DOES NOT SEEM TO
MATTER. ANY HELP WOULD BE APPRECIATED.

I am trying to convert an access database created in 1997 version to the 2002 version but get an error message each time I try.  Does anyone know any easy way to solve this?
Thanks.

I have a text file 13187 characters long. It will not
import or link.  Any suggestions?

Is there a tool that converts the queries form access2002 to sql sarver?
monther

I received a Database with a number of tables that each contain 24272
rows of data. When I export any of the tables to Excel a table is
created in Access with the name of the Exported file and the word Error
which contains 2 fields -- One field states: "Rows dropped due to