MS Cloud and Access DB - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

MS Cloud and Access DB

Chuck Hobbs

5 years ago

I store my Access DB in the MS Cloud. I have a PC and a Laptop that I work on. I stopped using the attachment images in order to not bloat my DB with pictures and replaced it with the images being stored in the same file folder as the DB and linking them to an image control on a form or report. This works great!

The problem is that the PC does not recognize the images that were linked on my laptop and vice versa. I never use both devices at the same time. I would like for both devices to recognize the images inputted by the other device. I suspect that the problem is the file name uses the device's name as part of the file path.

Is there a fix for this or do I have to get cloud service such as Drop Box that may not require that the device be part of the file path?

Thank,
Chuck

	Richard Rost @Reply 5 years ago
The relative path needs to be the same for both devices. I would suggest using something like Google Drive for Desktop where you can assign a drive letter like `G:\My Drive\MyPics` to that folder. While I would never run an Access database from inside a cloud drive like that, it should be safe to store your images there for the database to refer to.

	Chuck Hobbs OP @Reply 5 years ago
I did both google drive and drop box and they both include the computer name in the path. I must not be doing something correct. Having the images just on the PC and not having them on the laptop is just annoying but not critical. I even tride using my home network to the same end. I suppose I should look into getting a server for my home.

	Richard Rost @Reply 5 years ago
You need to map a drive letter, so they're both pointing to Z:\ or G:\ or something.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View