Devart Forums

I have a TUniConnection a TAccessUniProvider and a TUniTable component.
The following lines of code work correctly in Windows XP-32bit, XP-64bit, W7-32bit:

UniConnection1->Open;
tabTest->Active = True;
tabTest->Last();
tabTest->Edit();
tabTest->Post();

In W7-64bit the tabTest->Post() instruction produces an error:

Microsoft (ODBC Microsoft Access Driver) Operation must have an updateable query

A separate test using a TODBCUniProvider component with a pre-configured ODBC entry on the SYSTEM DSN page using a Microsoft ACCESS ODBC driver functions correctly on W7-64bit. However I do not wish to use preconfigured ODBC entries.

Does anyone know how to solve this problem ?

Hello,

I cannot reproduce the problem you described.
I have checked this behavior using the following configuration: Win 7 x64, C++Builder XE, UniDAC 3.70.0.17, MS Access 2007.

Please specify the exact version of UniDAC, C++ Builder and Ms Access. Besides, please send a small example that demonstrates the problem as well as the database to the following address: alexp*devart*com.

I have spent all week solving this problem and the answer is simple.

My deployment installation program (InstallShield), which is the one that produces the problem, installs the database file into an application subfolder created in the Common Applications Folder with no regard to the folder permissions.
I had assumed that the default permissions for the Common Application Folder would include Write permissions for the user but this is incorrect - certainly on the 3 W7-64-bit computers that I have used.

If the user has write permissions for the Common Application Folder subfolder then the POST operation succeeds. If the user does not have write permissions then the POST produces the ODBC Updatable Query error message.

I am sorry if I have wasted your time but I have learnt something today !

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.