Search results

Hi there, I'm pulling data from my Wordpress database (charset utf8mb4_unicode_ci) via MySQL Connector 8.0 into MS Access. This has worked well until I had to restore a backup on my website using Duplicator Backup Plugin. Now, all German Umlaute (ä, ü etc.) and other letters like ß are displayed...

Hi there, I'm using Access together with a MySQL database as the backend. Whenever I hosted the database with a shared hosting provider (remote access via ODBC), the connection performance was just not sufficient even though my queries are not that complex. In some tables we have a few thousand...

Hi there, I'm working on pulling order data from our web shop into MS Access which works pretty well. Now I'd like to copy files uploaded by customers within the order process onto our drive via FTP. Unfortunately, I only know part of the path - my URL/order_ID/unique_ID/files .... As I cannot...

Hi there, I'm trying to fetch data from a Wordpress database into MS Access. In picture below you'll see how Woocommerce (the shop plugin of Wordpress) stores user data. I'm now trying to build a query to fetch the different user data at once (e.g. _billing_first_name, _billing_last_name...

Hi there, in the past, I've used the MySQL Connector 5.1 driver to connect to my MySQL database. For several reasons, I now had to update to MySQL Connector 8.0. Unfortunately MySQL Connector 8.0 doesn't support my German Umlaute by default (ä, ü etc.). What I read about this is "The default...

Hi there, I'd like to connect my MS Access front end with my Woocommerce shop via REST API. However I need help with establishing the connection, using the JSON parser (https://github.com/VBA-tools/VBA-JSON) for the start. After that I'll be able to build the sqls to pull the data I need. Has...

Hi there! I have a strange error that's really frustrating me. A client of mine is trying to run my app in the same environment I have (Win 10, Office 365 32 bit) and she always gets the error: "The expression you entered has a function name that Tradumanager can't find". With all other users...

Hi there, I'm connecting from my Access FE to a MySQL BE database. This is my connection string: Constr = "Driver=MySQL ODBC 5.1 Driver;" & _ "Server=" & server & ";User = " & user & ";Password = " & pw & ";Database=" & datenbank Now I would like to make this independent...

Hi, currently I access my backend / data, that is stored in an online database, via ODBC. Some users of my app are complaining about the connection speed. Now I would to explore the option of storing the database in SharePoint. Do you guys have experiences with the speed of both methods? Is...

Hi, I bought a new PC and installed the newest Win 10 and Office 365. On my old PC, I had the same configuration, but older builds of Win 10 and Office 365. Before switching to the new PC, I had no problems with my Access app. The backend is a MySQL database, the connection is created with...

Hi there, I have a multi-user Access 2013 app . In order to access the application remotely I'm looking for a solution that I can install on a virtual machine and then connect to from anywhere. Can anyone recommend solutions to implement such a scenario? It's especially important that the...

Hi, I have certain problems with my accde file (compiled with Access 2016) when executed on PCs with older Access full versions installed besides the Access Runtime 2016. Despite forcing the use of the Runtime with the following link... C:\tm\tm.accde /runtime ...Windows tries to open the app...

Hi there, I have a strange problem with CurrentProject.Path - I use it to get the path of a another configuration file that is located in the same folder where my accde is located. When somebody else opens the accde on another machine, CurrentProject.Path does not give the new current directory...

Hi there, without any problems I execute a macro in a Word file from Access with this command: Application.Run MacroName:="fill_with_data"Now I would like to pass a parameter with this command: Application.Run MacroName:="fill_with_data", varg1:=strDirectoryPathIn Word I retrieve the variable...

Hi there - I would like to install my Access app on machines in Japan running with Japanese OS. The users told me about problems on start up which is why I switched my System locale (Win 10; Access 2007) to Japanese. The first error message I get is: When I want to check the code for problems...

How to use sha hashing Hi there - I'd like to access data that I use in Access also via browser/php. For the login, I'd like to use a secure encryption method for passwords etc. MD5 seems to be unsecure - so now I'd like to implement sha encryption via Access VBA and in the browser/php. Has...

Hi - this has already taken me days....:-/ When I try to add a column via SQL to the table employees I get the following error: The database engine could not lock table employees because it is in use by another person or process.With my other tables the command works (tried it to make sure the...

Hi there - I'm trying to select translators who are available today. For this I'm checking against the entered absence times - how can I list also translators for whom no absence times where entered? (these are obviously available...) Thanks for help! FRANK SELECT DISTINCT...

Hi there - I'm using a great treeview component from http://www.jkp-ads.com/articles/treeview.asp using fm20.dll/Microsoft Forms Object Lib because I had issues with mscomctl.ocx. Now a user of my application doesn't see the treeview. Probably fm20.dll is missing or corrupted. Is it sufficient...

I found a very nice example of how to implement a Treeview with VBA, without ActiveX/mscomctl.ocx: http://www.jkp-ads.com/articles/treeview.asp Unfortunately I'm not capable to use this example for my access database. Has anybody ever tried this and can someone provide a simple implementation...