Converting Access to Fox Pro


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 11 of 11

Thread: Converting Access to Fox Pro

  1. #1
    Bryan Guest

    Converting Access to Fox Pro


    How do I convert Acccess data so Fox Pro can manipulate the data and print
    it out. My objective is to print reports for an accounting application created
    by Access. I want to transfer the control to Fox Pro and then back to Access.
    I am going to have Visual Basic be the driver.

    Any suggestions?

  2. #2
    Garrett Fitzgerald Guest

    Re: Converting Access to Fox Pro

    In article <39256aad$1@news.devx.com>, bjs1117@ksu.edu (Bryan)
    quoth...
    > How do I convert Acccess data so Fox Pro can manipulate the data and print
    > it out.


    The short answer is, create a remote view in VFP against an Access
    ODBC datasource, and report off that remote view. If you need more
    help, please post more specific questions. Good luck! :-)
    --
    Garrett Fitzgerald
    #INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
    (Anyone who thinks I do anything vaguely resembling speaking for
    Microsoft is sorely deluded...)

  3. #3
    Bryan Guest

    Re: Converting Access to Fox Pro



    I do need more help but I have never been taught nor messed around with FoxPro.
    I do know though that there is another guy creating reports in FoxPro format
    and I am suppose to be able to export the Access data so FoxPro can manipulate
    it and then return the control back to the user in Access.

    Thnks,
    Bryan



    Garrett Fitzgerald <gfitzger@nyx.net> wrote:
    >In article <39256aad$1@news.devx.com>, bjs1117@ksu.edu (Bryan)
    >quoth...
    >> How do I convert Acccess data so Fox Pro can manipulate the data and print
    >> it out.

    >
    >The short answer is, create a remote view in VFP against an Access
    >ODBC datasource, and report off that remote view. If you need more
    >help, please post more specific questions. Good luck! :-)
    >--
    >Garrett Fitzgerald
    >#INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
    >(Anyone who thinks I do anything vaguely resembling speaking for
    > Microsoft is sorely deluded...)



  4. #4
    Bryan Guest

    Re: Converting Access to Fox Pro



    Plus he wants me to have VB as the driver of this accounting application.
    Basically the database is going to do some functions but more or less just
    hold the information.


    Garrett Fitzgerald <gfitzger@nyx.net> wrote:
    >In article <39256aad$1@news.devx.com>, bjs1117@ksu.edu (Bryan)
    >quoth...
    >> How do I convert Acccess data so Fox Pro can manipulate the data and print
    >> it out.

    >
    >The short answer is, create a remote view in VFP against an Access
    >ODBC datasource, and report off that remote view. If you need more
    >help, please post more specific questions. Good luck! :-)
    >--
    >Garrett Fitzgerald
    >#INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
    >(Anyone who thinks I do anything vaguely resembling speaking for
    > Microsoft is sorely deluded...)



  5. #5
    Garrett Fitzgerald Guest

    Re: Converting Access to Fox Pro

    In article <3925aa9e$1@news.devx.com>, bjs1117@ksu.edu (Bryan)
    quoth...
    > I am suppose to be able to export the Access data so FoxPro can manipulate
    > it and then return the control back to the user in Access.


    Like I said, don't export the data: use an ODBC connection to access
    the data live. Of course, your mileage may vary....
    --
    Garrett Fitzgerald
    #INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
    (Anyone who thinks I do anything vaguely resembling speaking for
    Microsoft is sorely deluded...)

  6. #6
    Bryan Guest

    Re: Converting Access to Fox Pro



    That sounds great but won't the user once it is packaged have to connect
    the database everytime they want to print or start up the application? If
    so that is very unfriendly.

    Bryan

    Garrett Fitzgerald <gfitzger@nyx.net> wrote:
    >In article <3925aa9e$1@news.devx.com>, bjs1117@ksu.edu (Bryan)
    >quoth...
    >> I am suppose to be able to export the Access data so FoxPro can manipulate
    >> it and then return the control back to the user in Access.

    >
    >Like I said, don't export the data: use an ODBC connection to access
    >the data live. Of course, your mileage may vary....
    >--
    >Garrett Fitzgerald
    >#INCLUDE "\Program Files\Microsoft Visual Studio\VFP98\stddsclm.h"
    >(Anyone who thinks I do anything vaguely resembling speaking for
    > Microsoft is sorely deluded...)



  7. #7
    Nancy Folsom [MS FoxPro MVP] Guest

    Re: Converting Access to Fox Pro

    "Bryan" <bjs1117@ksu.edu> wrote in message news:3925bcbd$1@news.devx.com...
    >
    >
    > That sounds great but won't the user once it is packaged have to connect
    > the database everytime they want to print or start up the application? If
    > so that is very unfriendly.


    Actually, I think that Garrett is talking about connecting from the FoxPro
    side. After all it's _your_ data that the Fox guy wants, right? Make _him_
    do the work <g>.

    And no, it wouldn't be user unfriendly, because the FoxPro program should do
    it.

    If it's not some external FoxPro program, and *just* FoxPro reports, then
    why are they using FP and not Access?



  8. #8
    Nancy Folsom [MS FoxPro MVP] Guest

    Re: Converting Access to Fox Pro

    "Bryan" <bjs1117@ksu.edu> wrote in message news:3925aaf9$1@news.devx.com...
    >
    >
    > Plus he wants me to have VB as the driver of this accounting application.
    > Basically the database is going to do some functions but more or less

    just
    > hold the information.


    Okay, so are you saying that VB will be used to create the front-end (UI) of
    an accounting application? With Access database as the backend (I hope you
    are using MSDE and not Jet), with, what? Foxpro doing the reporting? That's
    not really making sense to me (IMO) for an application architecture. Just
    my .02 U.S., but FoxPro could do it all, _or_ use VB for the front end with
    MSDE data engine (access) as the back end.





  9. #9
    Bryan Guest

    Re: Converting Access to Fox Pro


    Nancy,

    I totally agree with what you are saying but he has already made his mind
    up that FoxPro is the way to go with reports because we are in a time crunch
    and they are already done. But I thought a good way to do it is VB front
    end, Access back end, and Access doing the reports but I am not in charge
    just trying to learn this as I go so I can keep my job.

    Thanks,
    Bryan


    "Nancy Folsom [MS FoxPro MVP]" <nancy_folsom@hotmail.com> wrote:
    >"Bryan" <bjs1117@ksu.edu> wrote in message news:3925aaf9$1@news.devx.com...
    >>
    >>
    >> Plus he wants me to have VB as the driver of this accounting application.
    >> Basically the database is going to do some functions but more or less

    >just
    >> hold the information.

    >
    >Okay, so are you saying that VB will be used to create the front-end (UI)

    of
    >an accounting application? With Access database as the backend (I hope you
    >are using MSDE and not Jet), with, what? Foxpro doing the reporting? That's
    >not really making sense to me (IMO) for an application architecture. Just
    >my .02 U.S., but FoxPro could do it all, _or_ use VB for the front end with
    >MSDE data engine (access) as the back end.
    >
    >
    >
    >



  10. #10
    Nancy Folsom [MS FoxPro MVP] Guest

    Re: Converting Access to Fox Pro

    "Bryan" <bjs1117@ksu.edu> wrote in message news:3925d5c1$1@news.devx.com...
    >
    > Nancy,
    >
    > I totally agree with what you are saying but he has already made his mind
    > up that FoxPro is the way to go with reports because we are in a time

    crunch
    > and they are already done. But I thought a good way to do it is VB front
    > end, Access back end, and Access doing the reports but I am not in charge
    > just trying to learn this as I go so I can keep my job.
    >
    > Thanks,
    > Bryan


    Yikes! Sounds like a challenge.

    But, I don't really understand. If the reports are already done, then are
    they already drawing your Access data?





  11. #11
    Cindy Winegarden Guest

    Re: Converting Access to Fox Pro

    You can always export the data as comma delimited ASCII or something,
    with a specific format and naming convention, and let the app that
    does the reporting find the files, set up an internal cursor, append
    the ASCII file, and run the reports.

    I agree with Garret and Nancy, your boss seems to be trying to paste
    an awkward set of pieces together in an effort to save time, and what
    he'll end up with is a difficult-to-maintain hodgepodge.

    You have my sympathies, working for someone like that. Not a good
    environment for you to learn about design issues.

    --

    Cindy Winegarden
    Microsoft Certified Professional, Visual FoxPro

    Duke Children's Information Systems
    Duke University Medical Center

    cindyw@duke.edu



    "Bryan" <bjs1117@ksu.edu> wrote in message
    news:39256aad$1@news.devx.com...
    |
    | How do I convert Acccess data so Fox Pro can manipulate the data and
    print
    | it out. My objective is to print reports for an accounting
    application created
    | by Access. I want to transfer the control to Fox Pro and then back
    to Access.
    | I am going to have Visual Basic be the driver.
    |
    | Any suggestions?



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center