>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