Thanks to everyone who replied! It was indeed an Access file size limit that I was running up against. I’m loading the data into a second database right now, and it’s working.

Thanks again. I appreciate that so many of you took the time to respond.

Best wishes,

Kevin

Kevin J. Garcia

Data Resources Planner

Northwestern Indiana Regional Planning Commission

(219) 763-6060 x 125

kgarcia@nirpc.org

From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Uppalapati, Sirisha
Sent: Tuesday, August 30, 2011 10:43 AM
To: ctpp-news@chrispy.net
Subject: [CTPP] RE: SF1 Access Shell Import Error

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

uppalapati@semcog.org

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 8^th 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!