Error -2147217900

[Yovanys7410]

Sorry about my English, I speak spanish

My problem is as follow:

I Have an Application in vb6 with access 97 as database, the way I protect de database is with Encryption, now I have opted to add more protection with an

MDW file containing users and group info, I know the way to do that.

The main access to the DataBase is through DataEnvironment.
All work excellent including in the Connection String the Jet OLEDB:System database to the path of the MDW file so the User ID and password
all the command work the right way, but there is a curious error with all Grouping command I Have in the DEnvironment, the error is the following:

Error -2147217900 (Instrucción SQL no válida, se esperaba DELETE, INSERT, PROCEDURE, SELECT O UPDATE)

Any Idea??

Thanks in advanced

[LaVolpe]

Welcome to the forums.

I don't read spanish, but it appears the SQL statement may be incorrect. You might want to post the sql statement you are sending to access. Also, this forum has a database section where you might find better assistance.

[Yovanys7410]

The strange thing is that I have two version of this system, both are the same, the only diferences is of course in the Connection String the protected one have.
with the unprotected version all work fine, including this grouping command
with the protected version all work fine but not grouping command

thank you for you response