Indes Not Found - Access 2000, import, using "MS step by step"

[me]

I am just trying to learn this program and in the section I am at I am
supposed to import a file from a dBASE 5. I get the msg "index not found". I
tried adding a key or something in regedit. I just saw this under linking in
google. No clue what that did but it didn't help. I still get "index not
found". Any links or suggestions on I fix this?

I doubt this is a problem but I have office 2000, and the book is for 2003.
I would think 2000 could or should still be able to import from other db's?

thanks

 

[Guest]

From reading this article, it sounds to me like the registry change is only
required if you have the Borland database engine installed on your PC:

ACC2000: Error 3015 "Index Not Found" Error Message When You
Try to Link or Import a dBASE File
http://support.microsoft.com/kb/285949

Did you try to follow the steps shown in this KB article (and in the
reference KB 248841)?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[me]

Oops, that was the link I meant to add. I did this with a "2" in the BDE
key. (like I know what I'm talking about......?? :O) )

Yeah that is what I did. Is this a windows problem or access?

thanks

 

[Guest]

Did you have to add the new BDE key, or just modify it's value?

Have you tried importing a different DBase file, just to verify that the
issue is not related to that particular file?

When you modified the registry, did you close Access and re-open it, so that
it would read the changed setting?

Finally, try navigating to the branch of your registry and exporting it.
Save the export as a text file. When you open it in Notepad, you should see
something like this (if I added the key correctly, based on the directions in
the KB article <smile>)

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase]
:
:
"BDE"=dword:00000002



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[me]

Ahhhh...... I didn't close access. (I was wondering if I needed to reboot or
something but I didn't) It didn't mention that.

When I exported the text file for the registry it was a lot more than what
you have shown. The closest thing I found which I think means the same thing
is this:
_____________________
Value 11
Name: BDE
Type: REG_DWORD
Data: 0x2
_____________________

Maybe I did that part wrong.....? After closing it and then trying it did
work. Thanks, I didn't think this was such a big deal but what I import here
gets used in a later exercise so I needed it.

Thanks again!!!

 

[Guest]

You're welcome. Glad I could help.

A good rule of thumb to remember for the future: Any registry change that
you make to affect how Access works should be tested only after closing and
re-opening Access.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________