FoxPro linked into project (SQL Server)

[Sander Verhagen]

Hi,


I am having MSDE running on our file server.
I am using my laptop to work it, with an Access Database Project.
I would like to link (not import) data from our FoxPro based contacts list
system.
I have tried this in so terribly many ways I cannot even start to elaborate.
So please, someone, tell me how to go about on this, so that I can do a
fresh attempt, from scratch.

Thanks already,


Sander Verhagen
[ (e-mail address removed) ]

 

[Guest]

Hi,
You could try setting up your Foxpro database as a
linked server in SQL Server(MSDE). Then write a stored
proc to access the data you need using a fully qualified
naming syntax. Use the SP as the source of the data in
your .adp project.

HTH
Chris

 

[Sander Verhagen]

Hi,


I got this to work by putting the FoxPro database on the same machine as
were MSDE is running. Sounds simple, eh ;-)

Gr.,


Sander Verhagen
[ (e-mail address removed) ]