[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@01CC66EE.475AE2D0] Best wishes, Kevin J. Garcia Data Resources Planner Northwestern Indiana Regional Planning Commission (219) 763-6060 x 125 kgarcia(a)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!