How big is your mdb file before you start the import? How big are the
records you're importing? That sounds like a lot of rows, but even rows as
large as 1K each should fit in a file that's not already bigger than 500meg.
It could also be the case that Access is running out of memory. As part of
the import, Access executes an INSERT query and tries to protect it with a
transaction. The idea is to import all successfully or none. Access saves
info in memory and on your hard drive to "roll back" all changes from a
failed query. You could try linking to the data source and then write your
own Append (INSERT) query. Set the Use Transaction property of the query to
No to avoid the transaction overhead.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Jeanette Garcia
Sent: Monday, May 01, 2006 10:59 PM
To: [email protected]
Subject: [ms_access] Max Size
I'm trying to import just under 420K records and am receiving a "Database
has reached maximum size" error. How can I import this file?
Thanks,
Jeanette~
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
