Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a MS-Access Db
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00854292
Message ID:
00854294
Views:
19
This message has been marked as the solution to the initial question of the thread.
>Hi friends!
>
>I´m not sure what I need exactly, but this is my trouble:
>
>My boss buy a new software (dental). But, There are a lot of things this software doesn´t have, so my boss ask me to obtain the data from it and complete all the process we need. So I need to:
>
>1.- Open the db and tables from my server (\\Servidor\f\somepath\the db.mdb)
>2.- Get some information, compare with my tables (DBF) and if necesary, store the information (SQL commands could help?)
>3.- The MSA database must be open Shared (If that works on Access) to avoid any conflict with the other software
>
>Any idea could help...
>
I saw this sample some days ago and will probably help you..
oAcc=create("access.application")
oAcc.OpenCurrentDatabase("C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb")
oMDB=oAcc.CurrentDB
oRs=oMDB.OpenRecordSet("customers")
?oRs.Fields(1).Name
?oRs.Fields(2).Name
?oRs.Fields(3).Name
?oRs.Fields(1).Value
ors.movenext
?oRs.Fields(1).Value
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform