We help IT Professionals succeed at work.

Windows 10 Access 2016 Plus Error 3024

Medium Priority
58 Views
Last Modified: 2020-02-20
Hi Experts,

Recently I upgraded to Windows 10 and Access 2016 Plus.  All of my software is totally up-to-date.

I have an Event that is is used to relink the FE to the BE Databases.  This code has been working for years both on a local PC and to network locations including Dropbox.  It still works on the local PC however it no longer works on Dropbox.

I have attaching a copy of the messgae and code for your reference although it is quite long and complex.

I checked Google and found numerous references to this error, none of which I was comfortable with as it is an area I am not well educated in so I have decided to come to you for a specific answer.

Thanks,
Bob C.Windows-10-Access-2016-Plus-Error-3.docx
Comment
Watch Question

Owner, Dev-Soln LLC
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2010
Commented:

I would strongly recommend against linking to the file in dropbox.

Lukasz Zielinskisoftware developer
CERTIFIED EXPERT
Top Expert 2008

Commented:
"Could not find file"... verify that path is correct and user that runs your software has acces permissions to it.

ziolko.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:

It sounds like you are not logged in to Dropbox.

Check, that the path specified is visible using Windows Explorer.



John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
Lets say it in another way..
Take the scenario that you have Access in an area for multiple users..everything is linked via gigabit LAN...only problem is that the file server is very small (VM) and it struggles along with other VMs ....and your network has some latency...not much ...just a few ms....well this was a real scenario that caused quite a headache as we had numerous issues...
Now leave the LAN and enter WAN (Internet)...trying to operate Access with a BE on dropbox...it just won't play nicely.
Bob CollisonSystem Architect

Author

Commented:
Hi Experts,

Thanks for your comments / suggestions.

Dale / John:
I appreciate that using Dropbox (or I assume 'other like services') may have substantial issues and so I guess the real solution is not to use them.  If you are aware of another internet based service that can be used I would certainly appreciate hearing about it.

To mitigate the sharing issues by multiple users I have incorporated the following:
- There is a switch to control whether the database is located on an actual PC/Server or the Internet.
- When User logs in if the switch is set to 'Internet' a check is made to see if someone is already accessing the database and if there is a message displays and access is aborted.

Lukasz / Gustav:
I am the User and I can double click on the database in Dropbox and it opens.

Thanks,
Bob C.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:

I am the User and I can double click on the database in Dropbox and it opens.

Then your application connects with another account than yours, and this account cannot login to Dropbox or doesn't have the rights to access your local cashed folder.

Bob CollisonSystem Architect

Author

Commented:
Hi Experts,

I have adopted the 'solution to not use Dropbox.

All of you were quire helpful wit this question.

Thanks,
Bob\ C.