It won’t work to follow the instructions. I have an existing simple database (MS Access 2003) with one table, and when I try to connect, after supplying the new name, program says “The connection to the data source “New Database” could not be established”, and underneath “The connection could not be created. May be the necessary data provider is not installed.” Can anyone tell me what is missing? I have uninstalled and reinstalled Libre Office, but that didn’t help. I did find an old thread/post about downloading some windows drivers, but that was pretty old. I’m using windows 7 pro sp1, 64 bit. Thanks! BTW, it crashes after I close the dialog box.
Edit: I guess I didn’t search very well at the start, I did find some possibilities in the past posts that I’m gonna try.
Following Ratslinger’s previous post, I tried the windows drivers first, didn’t work for me. I think my version of MS Access was 32 bit, downloaded 64 bit drivers, uninstalled the old ones first as they said. I had previously uninstalled Office and Access.
Then I followed your instructions for UCanAccess. When I got to test connection, it said “The connection could not be established”. I went ahead and saved the new file, and got the message “The connection to the external data source could not be established. No SDBC driver was found for the URL ‘~jdbc:ucanaccess//D:\Acadjobs\projects\PROJECTS1.mdb’.” I may have to load MS Office with Access again, because this is what I keep all my project info in, clients, etc, and I will need it tomorrow. I was hoping to cut the umbilical cord and yearly rent from them. Thanks for your time and help. Terry
Add: Well, I got a new message: "“The connection to the external data source could not be established. An unknown error occurred. The driver is probably defective.” I had downloaded the UCanAccess v 4.04 compressed file, so maybe I should be doing something different? Should I be using Jaccess in parameters somehow ?
I’m afraid I’m not very knowledgeable in database or Java, my thing is Cadd.