VBA & Paradox Database

[Joey]

I am using Office 2003 Prof. Through VBA in word trying to access an access
databaise which updates from a paradox database - hope this makes sense. I
have downloaded the latest jet engine but I keep receiving an error message
"External table is not in the expected format" when trying to open the
paradox dbase through access. Any suggestions?

 

[Bob Buckland ?:-\)]

Hi Joey,

You may want to also post this in the Word VBA
newsgroup (link below) but it sounds like the table in the
file may be corrupted, although you may want to
post more information on the coding your using, the
method and the results you're trying to achieve.

=======
I am using Office 2003 Prof. Through VBA in word trying to access an access
databaise which updates from a paradox database - hope this makes sense. I
have downloaded the latest jet engine but I keep receiving an error message
"External table is not in the expected format" when trying to open the
paradox dbase through access. Any suggestions?>>
--
LLet us know if this has helped you,

Bob Buckland ?
MS Office System Products MVP
*courtesy is not expensive and can pay big dividends8

A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.word.vba.general
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.word.vba.general

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Neil Howie]

You haven't by any chance upgraded the Paradox table to a later version?
ODBC doesn't handle Paradox above version 5. Just a thought.

--
Neil

Anti-spam - Domain is really oakleaf ~ idps ~ co ~ uk (change ~ to dot)


|I am using Office 2003 Prof. Through VBA in word trying to access an
access
| databaise which updates from a paradox database - hope this makes
sense. I
| have downloaded the latest jet engine but I keep receiving an error
message
| "External table is not in the expected format" when trying to open the
| paradox dbase through access. Any suggestions?

 

[Joey]

Thanx for the feedback. Using Paradox Version 4.0. Solved the problem. I
didn't have the BDECFG32.exe installed on that particular computer. Working
like a dream now. Once again, much appreciated. Just further info. If you use
paradox above 5 then you need different drivers which is obtainable from
Microsoft site.