Search:

It is fixed by adding the exe file to windows DEP List.

In a VB6 project in Japanese Win10 OS machine, this line is working fine during the code running and debug.


Private lReport As CRAXDRT.Report
...
...
...
Call lReport.PrintOut(False, 1)
...

Thank you for your time.
It is true. you are right about the query.
I found some people use a XML middle step to recreate a new query but it negatively affects the performance drastically.
please...

Thank you so much for your help.
I was doing this and double checked after your last answer and everything looks exactly like you are suggesting.
But I get error when using to update recordset like...

yes I am trying to do that, but grid is readonly whatever I do. grid..column(index).lock =true not working.
cannot edit grid.

thanks but is not an efficient solution form me.
there are couple of columns need to be edited before population, dynamically.
the datagrid is read-only all the times.

Hi,

I have connected my DataGrid to a disconnected ADO Recodset.
Now I need to edit some columns just for population purposes and never update the database.

What is the best way to do that?
...

Thank you all.
:wave:

With Access I have problem with the security. People can open the database and manipulate it even with a complicated password. I guess it is much more harder with SQL even its not impossible.

My question specifically is about SQL LocalDB. Is it possible to make connection between VB6/ADO and SQL LocalDB? In case I decided to replace the Access with SQL?

Yes, you are right. The problem is we should set the compatibility mode and administrator mode on their machines. is there any ways to do that automatically?

For existing project, yes it is App.Path

Hi folks,

I have to support a VB6/ADO/Access application that working fine in 32bit XP and Win7 but have problem on Windows 10.
I am going to move on from the Access to SQL server Express/LocalDB...