Hello Kevin,
Access has a 2GB limit, it is possibility that you have hit that limit. The easiest way around is to make a copy of empty database with the remaining table shells and import the data in there. Once you reach the limit on that you will have to create one more database with the remaining tables and so on.
Regards,
Sirisha
Sirisha Uppalapati
Data Analysis Group
313-324-3440
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Kevin Garcia
Sent: Tuesday, August 30, 2011 11:11 AM
To: ctpp-news@chrispy.net
Subject: [CTPP] SF1 Access Shell Import Error
Hello Everybody,
I’ve been following the steps to import the SF1 data into the Access table shell. Everything was working smoothly until I got to the 8th table to import, and then I got the following message:
‘Cannot open database “ . It may not be a database that your application recognizes, or the file may be corrupt.’ (See screenshot below.)
I tried importing the next table, and got the same result. Has anyone run into this problem? I’m at a loss because, as I said, everything was working fine previously. Any help is much appreciated. Thanks!
Best wishes,
Kevin J. Garcia
Data Resources Planner
Northwestern Indiana Regional Planning Commission
(219) 763-6060 x 125
kgarcia@nirpc.org
p.s. I used a program called Greenshot to capture the above image. It’s like a much better “print screen”. It’s free and totally worth checking out: http://getgreenshot.org/downloads/. I share this with all my friends!