Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MultiUser Fox and MultiUser Access
Message
From
07/05/2012 04:57:04
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
06/05/2012 17:37:04
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:
01543249
Views:
72
>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform