Connecting to MS ACCESS from WinSQL

Aiysha
Aiysha used Ask the Experts™
on
I get this error when i try to connect an access database on the network to WinSQL

sqlError.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
What is WinSQL??

But it seems, that you haven't specified the path and filename of your Access database file..

Author

Commented:
ste5an,
Please see attached image of the software download site. Its a tool for working with different databases. I was able to create ODBC and connect to a database sitting on the sql server however the connection fails with access database sitting on the network drive.

You help will be highly appreciated.
WinSQL.JPG
ste5anSenior Developer

Commented:
But it seems, that you haven't specified the path and filename of your Access database file..

Does this "tool" has read/write access for your network path? Did you correctly specify it?
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Top Expert 2016

Commented:
the ODBC applet can be issued by typing odbcad32.exe after WIN+R (or at the start menu)

the applet will show all ODBC drivers currently installed.

if MSACCESS ODBC driver is missing you should get the requested ODBC drivers when installing Visual Studio and SQL Server. the Community versions of Visual Studio are free.

Sara
Ryan ChongSoftware Team Lead

Commented:
I was able to create ODBC and connect to a database sitting on the sql server however the connection fails with access database sitting on the network drive.

I think the error mentioned in your question is software independent, so I guess WinSQL just use an ODBC Data Source setting to connect to that target database. Not really problem within the WinSQL software. So the issue could be residing in the ODBC Data Source setting that connect to an Access database that sitting on the network drive.

try do as what Sara suggeted above and try create an ODBC Data Source setting that first must be workable. Make sure you got enough privileges to acccess to that Access database that sitting on the network drive.
Top Expert 2016

Commented:
WINSQL is a database tool which includes the following ODBC drivers:

ODBC Drivers for Oracle, DB2, MS SQL Server, Informix, Sybase, Pervasive, Text, XML, dBase, FoxPro, Paradox

MS ACCESS driver seems to be missing. that is a rare case cause many application will bring this driver with their installations. you may check the docs of WINSQL how to add missing ODBC drivers. you also may check whether there is problem with 32-bit drivers and 64-bit ones. for ms access there are both variants available but WINSQL most likely needs the 32-bit driver. sometimes there is an issue with permissions of the odbcad32.exe. if so, you might have to search for that file and run it 'as administrator' if it doesn't allow to create system data sources.

Sara
Top Expert 2016

Commented:
the LITE version of WinSQL doesn't include ODBC drivers at all.

Sara

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial