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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Jami Garrison
Sent: Tuesday, August 30, 2011 10:25 AM
To: ctpp-news@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@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Kevin Garcia
Sent: Tuesday, August 30, 2011 8: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
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!