[CTPP] RE: SF1 Access Shell Import Error

Thank you, Jami. It sounds like that's my problem. I'll follow your advice and make myself some more Access files to handle all this data. Thanks again! -Kevin From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jami Garrison Sent: Tuesday, August 30, 2011 10:25 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: SF1 Access Shell Import Error Yep! You ran out of space in your Access file- this is a limitation of Access. You have to start a new access file. I put tables 1-7 in one file, tables 8 thru 12 in another file and tables 13-47 plus the geography table in another. Then I opened a new access database and linked to the tables in those three access files so I had access to all the tables in one access database. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Kevin Garcia Sent: Tuesday, August 30, 2011 8: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:image001.jpg@01CC6702.73FE4160] 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!