If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Ended up with a paradox database...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-05-04, 14:45
calallone calallone is offline
Registered User
 
Join Date: May 2004
Posts: 4
Red face Ended up with a paradox database...

One of our suppliers created an ordering system on CD that uses a paradox database. I'm not at all familiar with this... which is my first problem.

What I have is a series of .db files, each appearing to be a table... that seems to be normalized. I don't know, however, how these tables got linked and yet are still separate files with no main program.

I tried to open them in Access, and it errored me out because the tables are linked. If I can't see the link, how can I edit the table?

I'm really just trying to change *one* field of *one* table to redirect where the orders are sent. I have more to do with it, but the whole thing's in German, which gives me oodles more fun for the future.

Please help!
Thanks!
Reply With Quote
  #2 (permalink)  
Old 05-06-04, 09:05
lmckelvy lmckelvy is offline
Registered User
 
Join Date: Oct 2003
Posts: 107
They are probably linked as lookups. There will be some support files with the same name as the table but with different extensions. The best solution is to use Paradox. If that is not an option, try this as a work around. Copy the table you want to work with to another folder without its support files. That should kill the links and you should be able to open it.

However, this may cause an index-out-of-date error or other problems when you run the program after modifying the table. As I said, the best solution is to use Paradox. You should be able to pick up an old copy on the net fairly cheap, but make sure it is at least version 7.
Reply With Quote
  #3 (permalink)  
Old 05-07-04, 15:30
dmant10 dmant10 is offline
Registered User
 
Join Date: May 2004
Posts: 2
I think I found something for you.

I stumbled across this across a viewer that might help. ODBCView 3.1.0 at www.download.com. Hopefully it will be able to export the info for you.
Reply With Quote
  #4 (permalink)  
Old 05-10-04, 15:16
calallone calallone is offline
Registered User
 
Join Date: May 2004
Posts: 4
Suggestions?

Well, looks like the best option is to get Paradox.... seems like the easiest method. I can't change the files without wrecking the links, and I tried making them readable, but they changed back promptly after. I tried a table viewer like the one suggested, but it still will not allow me to update.

Is there a suggested version of Paradox I could use? Also, any suggestions of where to go for documentation? Thanks so much!
Reply With Quote
  #5 (permalink)  
Old 05-20-04, 04:37
Shores Shores is offline
Registered User
 
Join Date: Aug 2003
Location: Bologna - Italy
Posts: 209
If the app you're speaking of has already been installed on the PC, you'll just need this little program i attach here to view and change the data in the files.

The only difficulty i see here, is that if the files are only on the CD, you cannot change them... they're read only!

Try this tool!
Attached Files
File Type: zip tblstruct.zip (270.4 KB, 130 views)
__________________
The only failure is not trying to do it.
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 On
Pingbacks are On
Refbacks are On