1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
{ DATABASE \d "C:\\Users\\Oliver\\Documents\\Access\\MaDB.mdb"
\c "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data
Source=C:\\Users\\Oliver\\Documents\\Access\\MaDB.mdb;Mode=Read;
Extended Properties=\"\";Jet OLEDB:System database=\"\";Jet OLEDB:Registry
Path=\"\";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=0;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
OLEDB:New Database Password=\"\";Jet OLEDB:Create System
Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy
Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex
Data=False" \s "SELECT `fac_Id`, `cli_Id`, `fac_Date`, `fac_DateLimPay`,
`fac_Total`, `fac_Paye`, `fac_Commentaire`, `fac_Nom`, `fac_Prenom`,
`fac_Societe`, `fac_Adresse`, `fac_Numero`, `fac_CP`, `fac_Localite`
FROM `tbl_Facture` WHERE ((`cli_Id` = 1))" \h } |
Partager