Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FPW2.6 tables, ODBC and MS Access
Message
 
To
16/06/2004 05:47:21
John Faithfull
Hunterian Museum, University of Glasgow,
Glasgow, United Kingdom
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00914163
Message ID:
00914216
Views:
10
I would not do this in Access... are they against using VFP?

>Hello folks,
>
>Probably a simple thing, but I'm not accustomed to using Access or ODBC.
>
>Managment want an app developed in MS Access which should share info from an FPW2.6 app.
>
>Linking via ODBC from MS Access is trivial (using the Visual Foxpro Database -- Free table) ODBC driver.
>
>However, I'd like to be able to make this table read-only, so that changes can only be made via the FPW application, which does audit trailing etc. Also I'm very dubious about the way the FPW26 and ODBC record locking may or may not work together during editing.
>
>Is there an easy way of doing this in MS Access? Or would this be best done at OS level by user-permissions? Any advice welcome...
>
>John
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform