Prev: Filter using query
Next: Issues after 2K7 Conversion
From: J_Goddard via AccessMonster.com on 22 Mar 2010 15:30
Hi -

To "link" to a file, use:

File - Get External Data - Link Tables

Set the Files of Type dropdown to dBase ... (.dbf), navigate to the directory
where the file is, select the .dbf file, and click "Link". IIRC, some
indexed .dbf files use associated index (.IDX ??) files - are these present,
if they are needed?

John



Steve wrote:
>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.
>
>> >> 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
>[quoted text clipped - 10 lines]
>>
>> .

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1

From: Steve on 22 Mar 2010 16:27
Not able to link because .idx file is not present.

"J_Goddard via AccessMonster.com" wrote:

> Hi -
>
> To "link" to a file, use:
>
> File - Get External Data - Link Tables
>
> Set the Files of Type dropdown to dBase ... (.dbf), navigate to the directory
> where the file is, select the .dbf file, and click "Link". IIRC, some
> indexed .dbf files use associated index (.IDX ??) files - are these present,
> if they are needed?
>
> John
>
>
>
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Filter using query
Next: Issues after 2K7 Conversion