Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect *.mdb file
Message
From
26/11/2002 10:16:24
 
 
To
26/11/2002 09:46:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00726963
Message ID:
00727002
Views:
12
>Hi at all,
>
>Is there any white paper explaining how connect Acces database to VP6 via ADO or ODBC?
>
>Why in my New form Connection, View and remote view are gray?
>
>Thank you in advance
>Luigi

Don't know of any whitepapers, simple ADO example follows:
oCn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Temp\db1.mdb;")
oRS = oCn.Execute("Select * From [myTable]")
? oRS.Fields(0).Name, CHR(9), oRS.Fields(1).Name
DO WHILE NOT oRS.EOF
	? oRS.Fields(0).Value, CHR(9), oRS.Fields(1).Value
	oRS.MoveNext
ENDDO
HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform