Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 25th, 2004, 02:20 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.


Reply With Quote
  #2 (permalink)  
Old October 25th, 2004, 03:29 PM
Authorized User
 
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"
Reply With Quote
  #3 (permalink)  
Old October 26th, 2004, 07:17 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Reply With Quote
  #4 (permalink)  
Old October 26th, 2004, 08:46 AM
Authorized User
 
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"
Reply With Quote
  #5 (permalink)  
Old October 26th, 2004, 11:57 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

John-
Thank u for the explanation.
Truly P.

Reply With Quote
  #6 (permalink)  
Old October 26th, 2004, 12:35 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Reply With Quote
  #7 (permalink)  
Old October 26th, 2004, 12:40 PM
Authorized User
 
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"
Reply With Quote
  #8 (permalink)  
Old October 26th, 2004, 03:05 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Reply With Quote
  #9 (permalink)  
Old October 26th, 2004, 03:20 PM
Authorized User
 
Join Date: Oct 2004
Location: Austin, TX, USA.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"
Reply With Quote
  #10 (permalink)  
Old October 26th, 2004, 03:27 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a gridview control w/access database p3aul ASP.NET 1.0 and 1.1 Professional 0 October 2nd, 2007 06:14 PM
Problem Updating MS Access database javlet Java Databases 1 April 24th, 2007 07:16 AM
updating database musicradiolive Classic ASP Databases 1 August 17th, 2006 12:23 AM
Help for Updating the database bspradeep Classic ASP Databases 1 May 10th, 2005 03:13 AM
updating yes/no field in MS Access database enigma82 Classic ASP Databases 2 May 6th, 2005 11:04 AM



All times are GMT -4. The time now is 11:16 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.