Search results

I started using Access in version 2013, and the computers in the office are all 2013+, so that shouldn't be a problem. I can probably get by with a startup script that adds DAO reference if it's not there. Yes, that's exactly what appeared when I used the Like operator. How it got switched to...

CJ_London: I don't know why I could not reply to your last post with a quote. The system wouldn't let me. Anyway, That is very interesting stuff. Thanks a lot!

I created both projects from scratch. Project 1 started as Access database and then was migrated to MySQL. I was going to base Project 2 on Project1 but there was too much work, so it was created fresh and linked to pre-created tables in MySQL. Project2 never has any Access native tables in it...

Yes I can. But it would be quite a pain if I have to add that reference on every single computer that's going to use my program. I'm trying to figure out why DAO wasn't there by default, as it used to be, and why the change of SQL syntax without my intervention. I wanted to know what's behind...

Thanks for the reply. I did not use connection strings. To use them, maybe I'd need to use ADODB, that's something I'd like to try out on my next project. What I did was, I downloaded and installed the ODBC Driver for MySQL from their website, then in the ODBC Data Source applet in Control...

Hi, I'm not a professional developer, just someone who knows some VBA and SQL, with just enough database knowledge to put some things together. I'm currently working on an Access (Office365 64-bit) front end that uses linked tables stored in a MySQL server on Ubuntu (via ODBC drivers). This is...