Hello

[NeedHelp4570]

Hello and HELP!
I work part-time as a Database Manager for over 10 databases. Each database has multiple users inputting data. I'm self-taught on Access. Been doing this for about 25 years. The company has switched everything to OneDrive. Long ago I wrote an app to do data entry and QA on the databases. After the IT department moved most of the stuff to OneDrive, I can't open my app. I get a message saying to check trust center (trusted location). The company won't let me add a user path. Everything has to be on OneDrive.
I use pictures that are on c:\. The message I get is access can't open c:\123.jpg. This needs to be changed to OneDrive location of the pictures. I can't find how to tell my app to look on OneDrive instead of c:\ drive. BTW-my app and all the pictures have been uploaded to OneDrive.
HELP!

 

[theDBguy]

Hi. Welcome to AWF!

Unfortunately, Access doesn't really play well with One Drive (or any other Cloud service).

 

[The_Doc_Man]

Take this note to your managers.

Because of protocol incompatibilities, Microsoft Access cannot operate correctly in a "OneDrive" or other cloud-like environment. Access MUST be hosted on a system that allows Server Message Block (SMB) protocol and that does NOT interfere with Windows File Sharing and Print Sharing (which is, again, SMB protocol). The actions performed by automated OneDrive backup are inconsistent with Access operation. Note that SMB has multiple versions. SMB2 or SMB3 would be acceptable.

If the database described by our member is critical to your company's operation then you need to back it off of OneDrive. There is NO SOLUTION that supports OneDrive. Further, if the goal was to somehow use OneDrive to enable the application for remote use over WiFi or Wide Area Network protocols, that will also be unstable, risking massive data loss.

Access must work in a Local Area Network environment where all users are on the LAN and no users rely on WiFi or other wireless transmission methods. Remote access to your data in a web-like environment will, in all probability, require that you convert all of the databases in question to use a formal SQL utility such as SQL Server, ORACLE, SYBASE, or any of the other SQL "engines" that are available.

- Richard Hunt, Ph.D. - 41 years computer experience including 28 1/2 years as a Systems Administrator for a major U.S. Navy Reserve personnel system. Holds HP OpenVMS 8.4 Systems Administrator certificate and CompTIA Security+ certificate. Former Microsoft Most Valued Professional 2008. Access World Forums member for over 20 years.

You can search the web for solutions that will enable Access for cloud usage but ALL of them are expensive and many of them are questionable.

 

[pbaldy]

Welcome. FYI I moved your thread out of the intro forum.