Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-12-2019, 04:42 AM   #1
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 329
Thanks: 204
Thanked 1 Time in 1 Post
Gismo is on a distinguished road
Can not open attachment loaded by other users

Hi All,

quick question, i have a DB to which we load attachments saved on the network server. the attachments are linked and not imported into the DB.
all are PDF format.
When I load an attachment, other can not open the link and visa versa.
any idea why and how to rectify? there is about 5000 records linked so it would not be feasible to re-link each and every one.

the message i get is "Unable to open ..."
Capture.JPG


Last edited by Gismo; 08-12-2019 at 05:34 AM.
Gismo is offline   Reply With Quote
Old 08-12-2019, 05:42 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,134
Thanks: 46
Thanked 969 Times in 950 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Can not open attachment loaded by other users

Hi. Not sure I understand. Are we talking about an Attachment field? Or, is it a text field? If text, can you post the code used to open it?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 08-12-2019, 05:45 AM   #3
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 329
Thanks: 204
Thanked 1 Time in 1 Post
Gismo is on a distinguished road
Re: Can not open attachment loaded by other users

this is an attachment field

Gismo is offline   Reply With Quote
Old 08-12-2019, 06:14 AM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,248
Thanks: 86
Thanked 1,624 Times in 1,507 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Can not open attachment loaded by other users

The folder where you put the external files needs to have its permissions checked. The folder should have an inheritance setting something like "Allow Read" to the folder and all folders and files therein. There IS a different "permission inheritance" setting that would allow reading only all child folders without referencing the files.

If the only thing you want to do is read or copy the files (which I suspect is true since they are PDFs), you don't need to set individual permissions. Your EFFECTIVE permissions include both per-file and per-folder permissions including inherited permissions. If you are having trouble with implementing this, you can show this comment to the sys admin, who should be able to diddle the permissions correctly.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 08-12-2019, 07:38 AM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,134
Thanks: 46
Thanked 969 Times in 950 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Can not open attachment loaded by other users

Quote:
Originally Posted by Gismo View Post
this is an attachment field
So, if it's an attachment field, then the files should be embedded in Access. However, you also said the following, so it was a little confusing.
Quote:
...the attachments are linked and not imported into the DB.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 08-12-2019, 07:46 AM   #6
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,002
Thanks: 20
Thanked 376 Times in 369 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: Can not open attachment loaded by other users

From your error message you are holding the path to the attachment, not using an Attachment field, as others have noted.

I'd check to see if there is a drive letter in there. If so, you may have an issue where individuals have different drive mappings. Likewise if someone is saving files on their local hard drive this can be a big issue.
Mark_ is offline   Reply With Quote
Old 08-12-2019, 09:40 AM   #7
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,248
Thanks: 86
Thanked 1,624 Times in 1,507 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Can not open attachment loaded by other users

Ah, I read it the other way... but if you don't put the attachments in the same place as the back-end file (or a child folder thereof), then you have a REALLY serious permissions problem - an over-distributed file repository.

Clarify where (physically) the attachment files are being kept because it will make a HUGE difference. An almost insurmountable one if Mark_'s question is relevant.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 08-12-2019, 09:24 PM   #8
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 329
Thanks: 204
Thanked 1 Time in 1 Post
Gismo is on a distinguished road
Re: Can not open attachment loaded by other users

Hi All,

Thank you for all the replies.
Sorry for the confusion, I am using a hyperlink data type field.
The DB is in the same folder on the network, all has the same access granted to the folder.
Also the drive mapping are the same on all pc's.
Not sure what else I could add to make this easier for you.
Gismo is offline   Reply With Quote
Old 08-12-2019, 09:37 PM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Can not open attachment loaded by other users

If you are just storing the paths to the external files, you would be better using a text field. Hyperlink datatypes can be problematic.

As the files are all PDF, users just need to view the files.
So you could modify the code so a local copy of each file is created for viewing and destroyed after use.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-13-2019, 12:57 AM   #10
Gismo
Newly Registered User
 
Join Date: Jun 2017
Posts: 329
Thanks: 204
Thanked 1 Time in 1 Post
Gismo is on a distinguished road
Re: Can not open attachment loaded by other users

The user must ba able to open the PDF when he has selected the related record.
Not sure a text field would work, would it?
will I still be able to link the PDF file if field is a text field?
Gismo is offline   Reply With Quote
Old 08-13-2019, 01:56 AM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Can not open attachment loaded by other users

Hi
Yes it works perfectly with a text field.
The simplest way to code it is
Code:
Private Sub Filepath_DblClick(Cancel As Integer)
Application.FollowHyperlink Filepath
End Sub
where Filepath is the name of your form control holding the path.
However that won't prevent the issue with network files being locked when opened by another user. You'll need to deal with that as I described before

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Gismo (08-13-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Preventing users from removing attachments from the Attachment Control in a Form Cark Forms 6 06-18-2019 07:57 AM
different attachment list for different users granaha Forms 1 01-02-2016 02:35 AM
Open Word MailMerge from Access with Data Source loaded sparkyrose Modules & VBA 0 01-30-2014 07:25 AM
Checking which NavigationSubForm is open/loaded conditional programming ? liamfitz Forms 4 02-19-2013 04:34 AM
Is my form loaded/open? ajetrumpet Access FAQs 3 11-17-2009 01:17 PM




All times are GMT -8. The time now is 08:16 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World