 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
hossein
Joined: 17 Oct 2014 Posts: 2 Country: Afghanistan |
|
SQL Assistant Add ins Problem on Access 2010 & 2013 |
|
Hi
Dear SoftTree team
I have a big problem and I've spent two days to solve this problem but have not been successful.
I installed SQL Assistant But i can't use it add ins in access 2010 or 2013
My MS office is 64x
You can see more information about my problem in below link :
https://www.dropbox.com/s/ngkt6596rdx371p/SQL%20Add%20ins%20problem.wmv?dl=0
Many thank in advance for your kind support
|
|
Fri Oct 17, 2014 4:12 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Hi,
SQL Assistant is 32-bit application and it works with 32-bit applications only.
If you want to use to work with MS Access queries, you can use the full-featured SQL development environment packaged with SQL Assistant, run sqleditor.exe, when prompted for database connection, select MS Access as the database type and pick your Access file.
|
|
Fri Oct 17, 2014 9:14 am |
|
 |
hossein
Joined: 17 Oct 2014 Posts: 2 Country: Afghanistan |
|
|
Sat Oct 18, 2014 3:23 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
The error message indicates that you likely have multiple MS Access ODBC drivers installed. the first one is Microsoft Access Driver (*.mdb) which is selected by default and that one doesn't know how to work with .ACCDB file, for which you need a different kind of ODBC driver Microsoft Access Driver (*.mdb, *.accdb)
On the Connection dialog, click the Options button, and then in the ODBC profiles (so called DSN names) and drivers drop-down list select Microsoft Access Driver (*.mdb, *.accdb), or alternatively choose a pre-configured ODBC profile for your .ACCDB file.
|
|
Mon Oct 20, 2014 12:57 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|