Search results

Thank you, I'll try it.

Sorry for being not specific enough - this is the REST API documentation for Woocommerce: https://woocommerce.github.io/woocommerce-rest-api-docs/#introduction - however VBA is obviously not mentioned there. It starts with the authentification process (example for PHP below) and continues with...

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...

Well, there are many users that use exactly the same accdb copy - and they are all working without any problems. So I don't know what you mean with "good copy".

Thank you for your detailed input. However, this is exactly what I tried - to look for missing references / problems with the references on the client's PC. Therefore I ran the app in accdb format (open) on her PC, but that led to the next error: The database cannot be opened because the VBA...

Well, the app is running error free on all other machines (+100 users), so I don't understand the point of restoring a backup. I have full control over the app on my PC and it gives me no errors at all. The backend is a MySQL database if that is of any importance...

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...

Nice, I'll give it a try... thx!

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...

Just to let you know - since a few days I'm using my accdb database again and there are no more problems, crashes, etc. So I guess that the issue has been resolved by recent Access updates…. FRANK

Unfortunately, nothing helped so far… however I have a "workaround": If I use my Access app in accde file format, there are no problems at all. Only if use my app in accdb file format, there are serious problems. So hopefully there will be some Office / Win updates soon that will eliminate the...

Thanks for the input. We'll use our frontend with MS SQL Server - as soon as I can compare the performance with MySQL, I'll share this here. Frank

Ok, I understand that SP is not offering a much higher performance. Yes, using MySQL as the BE is quite convenient, but I want to increase speed somehow. Has someone ever compared MySQL and SQL Server in terms of speed when used as backend for an Ms Access app? I always used MySQL because it's...

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...

Thanks, I'll try decompiling/recompiling. I never did it before. Just wanted to add that when I run my Access app as accde (the way I distribute it) there are no problems at all with Access or the MySQL connection (it behaves like before I got the new PC). Thanks for helping!! FRANK

...that doesn't help! Problems with both ways. Thanks though!

It's strange - my partner has the same build as I do (Win 10 1803). She has Win Pro though. She doesn't experience any problems at all with the same Access app configuration (ODBC connection etc.). However, I did a fresh install and she probably updated from a previous build. What could be the...

Thanks, that are exactly the problems I'm facing. Changing DisableLeasing registry value didn't help though. I think I have to downgrade Win 10 to build 1709. Is that possible when I didn't update Win 10 but simply installed a fresh Win 10 on a formatted hard disk? FRANK

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...

Thank you, so I need to go for a Remote Desktop server I guess. The app is deployed via Runtime. Can you recommend any Remote Desktop server software? Or will the windows inhouse solution be sufficient? Thanks, Frank