General information
Category:
Installation, Setup and Configuration
Environment versions
Network:
Windows 2000 Server
>>>Hi. Can multiple-users of VFP exchange info with multiple users of MS Access? My company has a program written in Access that they want to make a part of my VFP network.
>>
>>If under "exchange info" you mean they write into each others' tables, it can be done, provided all such tables have primary keys, or at least a field which can be used as one. You'd need an ODBC connectstring and the driver for it (which is probably already installed on each workstation, but may be worth checking). The trouble with connecting to Access is that you need a full path to the mdb file in the database= entry, and that path would differ among workstations, unless all workstations map the drive identically, or you use an UNC. If the Access app uses SQL instead of mdb, then it's a lot easier.
>>
>>Just be careful out there, you never know if the authors of the access app may blame your app for some of their own bugs.
>
>Hey, it's ALWAYS Foxpro's fault (grin)
As I recall, one of the reasons Microsoft bought FoxPro was to include Rushmore Technology into its preeminent product – Access. You remember Access? That was the database product that would allow any Manager to create a relational database application, to insure that his/her business was profitable. At least that is what the Microsoft salesman told a company I worked for. I never met a Microsoft sales type that heard of FoxPro. Working in Silicon Valley allowed me to meet many.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only