From: michelle@compumail.net   
      
   Dominick,   
      
   Since you are well versed in Access, you should have no problems   
   familiarizing yourself with Paradox tables.  The most common field types   
   are listed below, along with their equivalent in Access.   
      
   Access (Text) = Paradox (Alpha)   
   Access (Memo) = Paradox (Memo)   
   Access (Number) = Paradox (Number)   
   Access (DateTime) = Paradox (Date), Time), (Timestamp)   
   Access (Currency) = Paradox (Money)   
   Access (AutoNumber) = Paradox (AutoIncrement)   
   Access (Yes/No) = closest is Paradox (Logical)   
      
   There are more, but those are the most common.  Does that help?   
      
   ~Michelle   
      
      
      
   Dominick DiMantova wrote:   
   > Thanks, Michelle; this was the best response I've gotten yet! I appreciate   
   > your reply to my original posting. There were two gentlemen here; they remind   
   > me of middle-agers, 50something, overweight, gray-haired, who think they   
   > know it all, who claimed that I was trying to cheat my way into a position,   
   > when all I'm trying to do is get familiar enough with paradox so that I can   
   > speak intelligently during a possible interview. The client needs to migrate   
   > paradox into an Access database, that's all and I know Access, but not   
   paradox.   
   > BTW, do you think there is documentation, out there, that shows a typical   
   > Paradox database structure?   
   >   
   >   
   > Michelle Burnore  wrote:   
   >> Dominick,   
   >>   
   >> There are numerous structures for Paradox, but these are the most common.   
   >>   
   >> *.DB - This is the physical table that contains your records.  It looks   
   >   
   >>   virtually identical to an Access table.   
   >>   
   >> *.PX - If the table is keyed (same principle as in Access), there will   
   >> be a file by the same name as the table with this extension.   
   >>   
   >> *.XG0, *.YG0, etc. - If there are secondary indexes on the table, there   
   >   
   >> will be files with these or similar extensions.   
   >>   
   >> From within Paradox Windows, you can open the Project Viewer which   
   >> lists Tables, Forms, Queries, Reports, etc. just as an MB file in Access   
   >   
   >> will.   
   >>   
   >> Hope that helps,   
   >>   
   >> Michelle   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)