Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MultiUser Fox and MultiUser Access
Message
 
To
07/05/2012 08:44:13
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01543239
Message ID:
01543261
Views:
54
>>>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
Map
View

Click here to load this message in the networking platform