Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifying Microsoft Access Tables
Message
From
18/07/2004 05:29:47
 
 
To
04/07/2004 21:16:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00920636
Message ID:
00925553
Views:
20
Hi,
1) Create DBC
2) Create Connection to MS Accedd mdb
3) Create REmote View for your MS Access table
4) Setup Update/Insert rules, check "Send SQL Update"
4.1) Don't forget about Access table must have primary key (field) - if its
autoincrement integer field, set this field as keyfield, and remove this field from update process.
5) Run Remote View.
6) Try Update/Insert/Delete - call TableUpdate()
7) If you want to same in code - look remote view source code

Denis.

>Has any one updated Access tables from Foxpro. I need to do it but nI dont know where to start,
Previous
Reply
Map
View

Click here to load this message in the networking platform