30 Aug
2011
30 Aug
'11
11:10 a.m.
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(a)01CC66FD.0F351D80]
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!
30 Aug
30 Aug
11:24 a.m.
New 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(a)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(a)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!
11:50 a.m.
New subject: [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(a)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(a)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(a)01CC6702.73FE4160]
Best wishes,
Kevin J. Garcia
Data Resources Planner
Northwestern Indiana Regional Planning Commission
(219) 763-6060 x 125
kgarcia(a)nirpc.org<mailto: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!
11:33 a.m.
New subject: [CTPP] RE: SF1 Access Shell Import Error
Kevin:
I just opened file 8 in Louisiana with TransCAD and it opened OK.
You might try to import it with excel and then import to access.
Perhaps, you might also have a damaged file.
Mike LeBlanc, AICP<http://www.planning.org/AICP/>
Planning Manager, Special Projects Division
Rosa Parks Transportation Center
Lafayette Consolidated Government
Department of Traffic and Transportation
P.O. Box 4017-C
101 East Cypress Street
Lafayette, LA 70502
Ph: 337-291-7179
Fx: 337-291-8458
Planning for the 21st Century<http://www.lafayettelinc.net/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Kevin Garcia
Sent: Tuesday, August 30, 2011 10: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(a)01CC6700.3C45A580]
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!
Confidentiality Notice: This e-mail message, including any attachments is for the sole
use of the intended recipient(s) and may contain confidential and privileged information.
Any receipt and/or response to this email may be considered a PUBLIC RECORD. If you have
received this email in error, please notify the sender immediately. Any unauthorized
review, use, disclosure, or distribution is prohibited.
Lafayette Parish Consolidated Government
705 W. University Avenue
Lafayette, LA 70506
http://www.lafayettela.gov
11:34 a.m.
New subject: [CTPP] RE: SF1 Access Shell Import Error
I got the same error at about the same point and found that I had hit the Access file size
limit. I just downloaded an empty shell and started with the next table. Everything went
smoothly from there.
Scott
Scott Festin, AICP | Planner | Wasatch Front Regional Council |
scott(a)wfrc.org<mailto:scott(a)wfrc.org> | 801.363.4230.x1113
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf
Of Kevin Garcia
Sent: Tuesday, August 30, 2011 9: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(a)01CC66F7.FA8DBD10]
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!
11:40 a.m.
New subject: [CTPP] RE: SF1 Access Shell Import Error
I had the same error after several attempts. It appears that this error occurs when the
database is too large for Access to process (hence the reason it occurs late in the game).
I found the error message to be obtuse and the process frustrating...
Kim
Kim Anderson
Associate Regional Planner
San Joaquin Council of Governments
555 E Weber Ave, Stockton, CA 95202
Direct Line: (209) 235-0565
Main Phone: (209) 235-0600
Fax: (209) 235-0438
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)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(a)01CC66EF.CAE601B0]
Best wishes,
Kevin J. Garcia
Data Resources Planner
Northwestern Indiana Regional Planning Commission
(219) 763-6060 x 125
kgarcia(a)nirpc.org<mailto: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!
11:42 a.m.
New 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(a)01CC6709.EE38D3D0]<http://www.semcog.org/>
313-324-3440
uppalapati(a)semcog.org<mailto:uppalapati(a)semcog.org>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)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:image001.jpg(a)01CC6709.BAA2CDA0]
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!
![cid:image002.jpg(a)01CC6709.EE38D3D0]<http://www.semcog.org/>](http://cid:image002.jpg(a)01CC6709.EE38D3D0]%3Chttp://www.semcog.org/%3E){kind=link}
12:57 p.m.
New subject: [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(a)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(a)01CC670B.F168A510]<http://www.semcog.org/>
313-324-3440
uppalapati(a)semcog.org<mailto:uppalapati(a)semcog.org>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)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(a)01CC670B.F168A510]
Best wishes,
Kevin J. Garcia
Data Resources Planner
Northwestern Indiana Regional Planning Commission
(219) 763-6060 x 125
kgarcia(a)nirpc.org<mailto: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!
![cid:image002.jpg(a)01CC670B.F168A510]<http://www.semcog.org/>](http://cid:image002.jpg(a)01CC670B.F168A510]%3Chttp://www.semcog.org/%3E){kind=link}
5086
days inactive
5086
days old
ctpp@listserv.transportation.org
7 comments
6 participants
participants (6)
-
Jami Garrison -
Kevin Garcia -
Kim Anderson -
Mike LeBlanc -
Scott Festin -
Uppalapati