Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    ileacy
    Guest

    Re: Access as ODBC conduit

    From the original question and this one, it seems that you may have to use a two step process.

    1)In Access import the data from the Paradox Tables in a format compatable with your Palm Application.
    2)Use the existing Palm synch app to move/update the data.

    This process may have to be reversed for transfer from Palm to PC.

    Your can also use the BDE/ODBC functions within Paradox.

    The answer to your original question (how much of Access is required?) depends on how complicated the synch process is.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    246
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access as ODBC conduit

    Thanks for the answer, Ian.

    I have been led to believe that I can use Access as a conduit. That is, I am told that I can set up the Paradox ODBC drivers in Access so that the Paradox tables themselves, not an imported copy, are accessable in Access. Once that is working, I believe that my Palm app synchs with the data via DDE calls to Access. In essence what is happening is that I am synching directly with the Paradox data.

    I have instructions on how to set up the synch. I need help setting up a minimal Access installation since I won't be using it other than as an ODBC server. That is, if I do a custom install, what components are necessary? What components can be omitted?

  3. #3
    ileacy
    Guest

    Re: Access as ODBC conduit

    Art:
    I will do some research on the minimum component issue, however, I think you are better starting with a Typical install to get things working. Other than disk space there should be no down side.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    246
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access as ODBC conduit

    Unfortunately, disk space is an issue. Thanks for the help.

  5. #5
    ileacy
    Guest

    Re: Access as ODBC conduit

    Art:
    I am going to move this thread back to Access.
    I will PM you when the move is complete.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    246
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access as ODBC conduit(2)

    This is actually the first question that I posted in the lounge. I posted it in the Access forum. Maybe someone frequenting this forum has some information.

    Many data apps sync with, or otherwise connect with Access for the exchange of data. I am trying to use one of those apps, but unfortunately, my data exists in Paradox format. In that I own a copy of Office 97, I am willing to install Access for the sole purpose of acting as an ODBC server, conduit for the Paradox data.

    My question is what is the minimum Access installation possible to accomplish this?

    Also, are there any other suggestions for setting this up?

    All recommendations apprecitated.

    Edit: Added link to original post

  7. #7
    ileacy
    Guest

    Re: Access as ODBC conduit(2)

    I have broken this thread into three separate issues. The question you have posed has a lot of different aspects to it.

  8. #8
    ileacy
    Guest

    Re: ODBC: Sync application

    Need some more details about the Palm/PC synch application. Can you post URL or describe how "it can sync Access data".

  9. #9
    ileacy
    Guest

    Re: ODBC: Access Version

    The methods for implementing Access<>Paradox depend on the version of Access. Which version are you using.

  10. #10
    ileacy
    Guest

    Re: ODBC: Paradox Version

    Access<>Paradox integration depends on version of Paradox and whether BDE is installed.

    Please describe.

  11. #11
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    246
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC: Sync application

    The Palm program is called thinkDB. It is a nice relational database that features lookup tables and one to many joins. On the Palm, one of its nicest features is a tabbed form interface that makes good use of the limited screen space. You can download the Palm app free at <A target="_blank" HREF=http://www.thinkingbytes.com/>http://www.thinkingbytes.com/</A>.

    There are two other components that allow you to move data back and forth between the Palm app and your desktop computer. One is the thinkDB desktop, and the other is dbSync.

    The thinkDB Desktop is an MS Windows program that can open the palm data (pdb) files, create and edit the Palm databases. It can import and export to Access 97 aand 2000, and CSV text files. It does not "synch" with the Palm. Rather, it is an overwrite of the entire datafile. So, it's great as an import/export utility, but you can't risk changing data on both the palm and the desktop between synchs.

    dbSync provides the ability to do a real record for record sync with Access 97 or 2000. In their listserv, however, a user was able to use dbSync to sync with Oracle 8i by using Access as an ODBC server for the Oracle data.

    I have been maintaining certain office records in Paradox since 1992. I would like to get the active records into thinkDB on the Palm using dbSync. I own a copy of Access 97 which came with Office 97 Professional. Besides some of the minor pieces like the photo editor, etc., the only major Office component that I use is Word. However, I am willing to install Access to use as an ODBC server.

    I hope I ahve provided the details that you need.

  12. #12
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    246
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ODBC: Paradox Version

    My Access version is 97 SR1.

    I use Paradox version 7. The tables are version 5 compatible. I have the newest version of the BDE installed as I got it with Delphi 5.

  13. #13
    ileacy
    Guest

    Re: ODBC: Paradox Version

    Ok. That is good. You need the BDE for best access to Paradox data from Access.

    The following Access 97 documents are relevant.

    ACC: How to Optimize Microsoft Access Using ODBC Data Sources
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/ARTICLES/Q113/5/51.asp>http://support.microsoft.com/support/kb/AR...S/Q113/5/51.asp</A>

    Using Microsoft Access with ODBC and Client/Server Operations
    <A target="_blank" HREF=http://www.microsoft.com/office/ork/027/027.htm#dex23>http://www.microsoft.com/office/ork/027/027.htm#dex23</A>

  14. #14
    ileacy
    Guest

    Re: ODBC: Sync application

    Art:
    I looked at the site. The dbsnyc info says

    <hr>db sync is your personal connectivity tool to MS Access and soon other ODBC data sources<hr>

    Given the planned enhancement (though I have no idea how real the commitment is) I think that waiting for fuller ODBC support in db sync would be the simplest job for you.

    I will post some other info on your options, but, in any event, I think you will have to install a minimal development version (ie. not runtime) of Access to implement the pass thru calls to Paradox.

    >>In their listserv, however, a user was able to use dbSync to sync with Oracle 8i by using Access as an ODBC server for the Oracle data.<<
    Can you post a link to that message thread, or, copy the text to here if you have it available in digest form only.

  15. #15
    ileacy
    Guest

    Re: ODBC: Access Version

    These are other relevant Access 97 documents.

    ACC: How to Search for Microsoft Access Articles by Keywords
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q119/5/26.asp>http://support.microsoft.com/support/kb/ar...s/Q119/5/26.asp</A>

    Access 97 Frequently Asked Questions
    <A target="_blank" HREF=http://support.microsoft.com/support/access/content/faq/faq97.asp>http://support.microsoft.com/support/acces...t/faq/faq97.asp</A>

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •