A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access crashes when importing dbf file



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 05:54 PM posted to microsoft.public.access
Steve
external usenet poster
 
Posts: 2,662
Default Access crashes when importing dbf file

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.
  #2  
Old March 19th, 2010, 06:28 PM posted to microsoft.public.access
Steve
external usenet poster
 
Posts: 2,662
Default Access crashes when importing dbf file

I want to add that when I say crash, I mean it simply disappears without any
warning or error messages.

"Steve" wrote:

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.

  #3  
Old March 19th, 2010, 06:52 PM posted to microsoft.public.access
lucas
external usenet poster
 
Posts: 1
Default Access crashes when importing dbf file


"Steve" a écrit dans le message de
...
I'm using Access 2003 and when I try to import a dbf file, Access crashes
on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.


  #4  
Old March 19th, 2010, 07:15 PM posted to microsoft.public.access
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Access crashes when importing dbf file

Any dbf file or just a particular file? If it's a particular file or file(s),
I'd try to find another dbf file from a different system and try to import it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve" wrote:

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.

  #5  
Old March 19th, 2010, 08:43 PM posted to microsoft.public.access
Steve
external usenet poster
 
Posts: 2,662
Default Access crashes when importing dbf file

This is with any dbf file.

"Jerry Whittle" wrote:

Any dbf file or just a particular file? If it's a particular file or file(s),
I'd try to find another dbf file from a different system and try to import it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve" wrote:

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.

  #6  
Old March 19th, 2010, 09:33 PM posted to microsoft.public.access
Paul Shapiro
external usenet poster
 
Posts: 635
Default Access crashes when importing dbf file

Did you also try a different computer? Or importing the dbf to Excel first?
The original dbf format was simply a fixed-length text file. If all else
fails, you could try importing it as fixed-length text. If I remember
correctly, the first character is a blank for a good row and a '*' for a
deleted row. The rest of the row is your data fields.

"Steve" wrote in message
...
This is with any dbf file.

"Jerry Whittle" wrote:

Any dbf file or just a particular file? If it's a particular file or
file(s),
I'd try to find another dbf file from a different system and try to
import it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve" wrote:

I'm using Access 2003 and when I try to import a dbf file, Access
crashes on
me. I've already tried repairs and uninstall/reinstall of Office but
that
hasn't resolved the issue. I also am up to date on all service packs
and
updates. Not sure what to try next.



  #7  
Old March 19th, 2010, 09:44 PM posted to microsoft.public.access
Jerry Whittle
external usenet poster
 
Posts: 4,732
Default Access crashes when importing dbf file

Can you link to the dbf file? (I think linking is possible).
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve" wrote:

This is with any dbf file.

"Jerry Whittle" wrote:

Any dbf file or just a particular file? If it's a particular file or file(s),
I'd try to find another dbf file from a different system and try to import it.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve" wrote:

I'm using Access 2003 and when I try to import a dbf file, Access crashes on
me. I've already tried repairs and uninstall/reinstall of Office but that
hasn't resolved the issue. I also am up to date on all service packs and
updates. Not sure what to try next.

  #8  
Old March 19th, 2010, 11:03 PM posted to microsoft.public.access
Bob Quintal
external usenet poster
 
Posts: 939
Default Access crashes when importing dbf file

=?Utf-8?B?U3RldmU=?= wrote in
:

I'm using Access 2003 and when I try to import a dbf file, Access
crashes on me. I've already tried repairs and uninstall/reinstall
of Office but that hasn't resolved the issue. I also am up to
date on all service packs and updates. Not sure what to try next.


Make sure the .dbf file name is eight characters or less.
ISTR that the import code balks at long file names on .dbf files.

--
Bob Quintal

PA is y I've altered my email address.
  #9  
Old March 20th, 2010, 02:49 PM posted to microsoft.public.access
Paul Shapiro
external usenet poster
 
Posts: 635
Default Access crashes when importing dbf file

"Bob Quintal" wrote in message
...
=?Utf-8?B?U3RldmU=?= wrote in
:

I'm using Access 2003 and when I try to import a dbf file, Access
crashes on me. I've already tried repairs and uninstall/reinstall
of Office but that hasn't resolved the issue. I also am up to
date on all service packs and updates. Not sure what to try next.


Make sure the .dbf file name is eight characters or less.
ISTR that the import code balks at long file names on .dbf files.

--
Bob Quintal

PA is y I've altered my email address.


Good point! I'd forgotten that but I also seem to remember now that Bob
mentions it. You might also try a local folder with no spaces in the folder
names, and maybe no more than 8 characters for the folder names too. It's
been a while since trying to remember back to DOS days.

  #10  
Old March 22nd, 2010, 07:36 PM posted to microsoft.public.access
Steve
external usenet poster
 
Posts: 2,662
Default Access crashes when importing dbf file

Thank you for the responses. This happens with all dbf files and all mdb
files on my computer. It works fine on other computers though so the issue
is just on my computer. Yes, I can import other file formats like Excel
files. So I could bring the dbf into Excel then from Excel to Access,
however, I perform this operation quite often so I would like for it to work.
When Access crashes, it creates the .ldb file and I have to open Access
again and close it for the .ldb to disappear.
And yes, I am using a dbf file w/less than 8 characters in the name and
there are no spaces in the path name...which is local.

If by "linking" you mean opening vs importing the dbf in Access then that
doesn't work either...it also crashes Access.



"Paul Shapiro" wrote:

"Bob Quintal" wrote in message
...
=?Utf-8?B?U3RldmU=?= wrote in
:

I'm using Access 2003 and when I try to import a dbf file, Access
crashes on me. I've already tried repairs and uninstall/reinstall
of Office but that hasn't resolved the issue. I also am up to
date on all service packs and updates. Not sure what to try next.


Make sure the .dbf file name is eight characters or less.
ISTR that the import code balks at long file names on .dbf files.

--
Bob Quintal

PA is y I've altered my email address.


Good point! I'd forgotten that but I also seem to remember now that Bob
mentions it. You might also try a local folder with no spaces in the folder
names, and maybe no more than 8 characters for the folder names too. It's
been a while since trying to remember back to DOS days.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.