Converting Access to Fox Pro

[Bryan]

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?

[Garrett Fitzgerald]

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...)

[Bryan]

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...)

[Bryan]

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...)

[Garrett Fitzgerald]

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...)

[Bryan]

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...)

[Nancy Folsom [MS FoxPro MVP]]

"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?

[Nancy Folsom [MS FoxPro MVP]]

"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.

[Bryan]

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.
>
>
>
>

[Nancy Folsom [MS FoxPro MVP]]

"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?

[Cindy Winegarden]

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?