Sir,

[kamleh patel]

Below connection String is working in 32 bit windows 10 but 64 bit windows 10 is not working.

CnAdo:Open("Provider=Microsoft.ACE.OLEDB.16.0;Data Source=agenda.accdb;")

Error is 

Please give me a solution.

Regards

Kamlesh.

[AL67]

Microsoft.ACE.OLEDB.16.0 is probably a component of MS Office 2016.
Got it installed?

Adam

[matt johnson]

Maybe you can turn on logging in ODBC configuration screen? 

--
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: https://groups.google.com/group/harbour-users
---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/harbour-users/2986c413-ad4a-4077-b46e-2ab0c16c46den%40googlegroups.com

.

[kamleh patel]

I am using ms Access and connection successfully. Single user is working perfectly. but multiuser in error.

My program is below.

   Local e
   Try
     IF (CnAdo:=CreateObject("ADODB.Connection")) == NIL
        MsgStop("ADO is not available.","Error")
        ExitProcess(0)
     ENDIF

           CnAdo:Open("Provider=Microsoft.ACE.OLEDB.16.0;Data Source=agenda.accdb;")

           oCursor:=CreateObject("ADODB.Recordset")
   Catch e
           MsgStop("Operation: "+e:operations"-"+"Description: "+e:Description+chr(10)+vMat(e:Args),"Error")
            ExitProcess(0)
   End

   oCursor:Open("Select * from contactos order by Apellido",CnAdo,2,3)

    

Regards

Kamlesh

[Ivanil Marcelino]

Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center

--
Visit our website on https://www.hmgextended.com/ or https://www.hmgextended.org/
---
You received this message because you are subscribed to the Google Groups "Harbour Minigui" group.
To unsubscribe from this group and stop receiving emails from it, send an email to minigui-foru...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/minigui-forum/CAPFyMQP5D0WgRqxGGzeFLZOnwVZTynqco8w_J5TCtTdq%3Dn3utg%40mail.gmail.com.

--

Ivanil Marcelino
Fone: 48-99129029

Skype: ivanilm...@hotmail.com

E-mail:
ima.so...@terra.com.br
ivanil.m...@yahoo.com.br
ivanil.m...@gmail.com

[ivanil.m...@gmail.com]

Good Morning;
Perhaps my report is not the solution to your problem, but it is worth reporting;
Some time ago I created an application subject to a lot of stress, simultaneous use of 4 users worked very well in field test; but putting it into production with about 15 users was a real cause.; I had to travel in a hurry and change the database to SQL Server, I just changed the connection and like magic everything returned to conformity;
Learning on my part;
Access for single-user use is fine; supporting up to a base with thousands of records, but in a multiuser environment the option is a DBMS, either Mysql, mariadb, post, firebird or even sqlserver, which has limited versions that still work very well;