 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
October 25th, 2004, 02:20 PM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Updating from no access database
Hi experts!
Having a paradox type Db table linked to A2K2 table how would the
link be updatable? I thought clicking Refresh would work but i was
wrong.
Regards Penta. 
|
|
October 25th, 2004, 03:29 PM
|
|
Authorized User
|
|
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
See:
http://support.microsoft.com/default...b;en-us;286246
The Paradox file must be version 5 or earlier, it must have a unique index, and you must have Jet 4 Service Pack 5 or later (via Windows update) or the Borland Database Engine (BDE) installed.
Hope that helps...
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
|
|
October 26th, 2004, 07:17 AM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
John-
I have treid to update my A2K2 to SP8 downloading from MS SC. Although i have
not been asked to inform the ProductKey as the instructions advised.
Am i out of the track?
Thanks.
Truly Penta.
|
|
October 26th, 2004, 08:46 AM
|
|
Authorized User
|
|
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Penta-
There is not SP8 for Access 2002 - but that is the latest service pack for the JET database engine, which is what you need. I don't believe you need a product key to download and install it. JET is a component of Windows now, not Access, so you're updating Windows.
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
|
|
October 26th, 2004, 11:57 AM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
John-
Thank u for the explanation.
Truly P.
|
|
October 26th, 2004, 12:35 PM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
P.S. -
I have posted the above message because i'm not sure of what went wrong.
I'm having error message:"external table is not in expected format" when
trying to link the tbs.
Any suggestion will be welcome.
|
|
October 26th, 2004, 12:40 PM
|
|
Authorized User
|
|
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Then the file must be a Paradox 7 or 8 file, and neither is supported by Access. You need to find an ODBC driver for this type of file and link it as an "SQL" database.
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
|
|
October 26th, 2004, 03:05 PM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
John-
We are talking about two links:
1. My machine(m1) that runs WinXp ;
2. Another machine(m2) that is the server and runs Win98.
In the mean time while i was having problem with m1, i tried to update(Access2002) in
m2 and the link has been OK after downloading SP7 from Microsoft.
M1 comunicate with m2 by an internal net and there in m1 i am having the error
message. Will the explanation match ur above post?
Truly P.
|
|
October 26th, 2004, 03:20 PM
|
|
Authorized User
|
|
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Are you able to open the table now that you have installed JET SP7? Or, are you still having the problem? Or, did the problem start after installing SP7. Your message is not clear.
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
|
|
October 26th, 2004, 03:27 PM
|
|
Friend of Wrox
|
|
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Before installing SP7 in m2 i was having problem on m1. I will try to open
the table now in m1 and i will let u know.
Truly P.
|
|
|
