Search results

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

I wanted to try the same - I deinstalled Office 2016, installed only Access 2010 and then reinstalled Office 2016. The accdb opens in Access 2010 but only in read-only mode. Restarting Windows didn't help. Did you have the same issues or can anybody give advice on how to proceed with this...

@ridders - I'm actually a translator and I didn't want to work with Office 2007 anymore so I updated to 2016. Since I distribute my app with Access 2016 Runtime there are often problems with users. The functionality of Access 2007 would have been totally sufficient though. Do you have Access...

Thank you for your input. I'm trying to implement a late binding ADODB connection in Word but I don't find any decent examples. Can recommend me a useful example/website? Avoiding references (the ActiveX reference in particular) would be great of course. @ridders: Are you saying that you...

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

The configuration_tm.accdb also stores information about if the user wants to connect to a local accdb or a mysql database. Then, in case the accde is updated/replaced by a newer one, the access data to the accdb or mysql db are kept and do not have to be entered again and again. Sorry for the...

I did test CurrentProject.Path in the Immediate Window, however it indicated always the correct path on my machine. Exactly, it seems to re-establish the last connection even though I tell the FE to use the user specific path to the accdb database file: Database_filepath_config =...

I have the feeling that I didn't explain the problem well - configuration_tm.accdb is in the same directory as the FE accde file and contains the path of the BE file. So I use CurrentProject.Path to open configuration_tm.accdb in order to open the BE file. However CurrentProject.Path sometimes...

Yes, Y: is a mapped drive. On my machine the app is on a mapped drive, and then on the other users' machine it's probably in c:\program files\.... Then on their machine they get the error "The file is not found in Y:\...." even though CurrentProject.Path should indicate the current location of...

FE and BE are split - it's not a multi-user app, I simply distribute the accde to other users that open it on their machine. configuration_tm.accdb contains information to establish the connection to the database (the location of the accdb or mysql access information). The problem has already...

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

No worries :-) Thank you for your input!! Regards, Frank

Well, my files ran without any error on JHB's machine, so I would really see the ODBC driver as cause for this error as this is probably the decisive difference between our PCs. As a workaround I now create a temporary txt file that I read into the Word file. Of course the direct transfer of...

Thanks for the input: - I tried the correct declaration of the variables as string - didn't work: Dim strFileName as string Dim strDirectoryPath as string Dim varg1 as string - There are no missing references. That's checked. - However the problem could be caused by using MySQL ODBC -> But why...

@Gasman: I was referring to a file provided in this thread by someone else. @The_Doc_Man: I tried with Word objects library activated but the error still occurs. Thanks for the advice though.

I triggered the error again but there is not error log in the application log for today. So apparently it's not logged there. However the exact message I get in Access is: Laufzeitfehler: '-2147352567 (80020009)': Automatisierungsfehler Ausnahmefehler aufgetreten.(literal translation...

Many thanks, however I can't open the .docm file at all (Win 10/Office 2013). Error message: "Die Datei kann nicht geöffnet werden, weil das Dateiformat nicht der Dateierweiterung entspricht" (translation - The file cannot be opened as the file format is not consistent with the file extension).

Strange, but I get the automation error again! All I did is: 1. Changed this line in your database to: strFileName = "Quote template_afp.docm" 2. Copied the beginning of your word file into mine: Public Sub fill_with_data(Optional strDirectoryPath As String) ' ' fill_with_data Makro ' Makro...

Yes, of course. Attached you'll find the Word template file. It's a bit lengthy though. Maybe you'll be directed to the error somehow. Thanks for taking a look, FRANK

Thank you, this help to narrow down the error. Your file works fine on my PC. I realized that the error occurs as soon as I add the optional parameter in my Word file: "Public Sub fill_with_data(Optional strDirectoryPath As String)". Even if I don't pass anthing to the Word file, the automation...