Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Thanks Eric, after having set the CursorLocation to "Client" then it
is alright now.
Another question. Is "Microsoft.Jet.OLEDB.4.0" the newest way to
connect to Access Databases? Could I say that I should stop using
"Microsoft.Jet.OLEDB.3.51"? Pls advise.
One last question. How could I set a password for an Access Database,
and use VB6 to open the Database with the desire Password?
The purpose is to prevent anyone to open the Database even from the
Access Application.
I tried the "Set Database Password", but my VB application could supply
the Password to open.
I also tried setting the User Account(in Access environment), but if the
Database(.mdb) is copied to another PC, it can be opened with another
Password setted. Pls advise, thanks.
>>I have change the Provider to :
>> cnn.Provider = "Microsoft.Jet.OLEDB.3.51"
>>and use Access 97. Everthing is OK.
>>
>>But if I were to use the Provider as:
>> cnn.Provider = "Microsoft.Jet.OLEDB.4.0"
>>and with Access 2000, then the records doesn't display on the DataGrid1.
>>
>>Now a little confused.....
>>Could you enlighten me what are the differences between the Providers
>>"Microsoft.Jet.OLEDB.3.51" and "Microsoft.Jet.OLEDB.4.0", and which
>>one should be used for Access 97 or Access 2000? Thank you very much.
>>
>I use the 4.0 version with both version of Access without any problems!
>
>Have you installed SP3 of Visual Studio?
>
>What is the CursorLocation, CursorType, ...?
>
>Make a small app that binds to NWIND or Biblio (and that reproduce your error) and show the code here!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement