[CTPP] RE: SF1 Access Shell Import Error

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(a)nirpc.org From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Uppalapati, Sirisha Sent: Tuesday, August 30, 2011 10:43 AM To: ctpp-news(a)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 [cid:image002.jpg@01CC670B.F168A510]<http://www.semcog.org/> 313-324-3440 uppalapati@semcog.org<mailto:uppalapati@semcog.org> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Kevin Garcia Sent: Tuesday, August 30, 2011 11:11 AM To: ctpp-news(a)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! [cid:image003.jpg@01CC670B.F168A510] Best wishes, Kevin J. Garcia Data Resources Planner Northwestern Indiana Regional Planning Commission (219) 763-6060 x 125 kgarcia@nirpc.org<mailto: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!