Re: [MSAccessProfessionals] Error 2302

Everyone may need to check their junk/spam folders for these emails. That's how I found the initial emails. 

I thought I had the email address in my safe senders list. 

Duane

Sent from my mobile

On Sep 11, 2024, at 11:34 AM, crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:



hi Doyce,

you're welcome. Please share the code you're using to create the PDF file

kind regards,
crystal

On 9/11/2024 11:06 AM, Doyce Winberry via groups.io wrote:

Crystal,

 

Thanks for your response. I have another user that uses a folder called Databases instead of Docs and the same issue occurs with this user. My server guys are telling me they don't think it is a KB. The strange thing is that this has worked for about the last 15 years with no issues.  Access is running on a shared app server with Server 2019 as the OS. Each user has their own login and their own copy of the front end.

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Wednesday, September 11, 2024 10:54 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Error 2302

 

ps, also, if you can't boot computer, remove drive and mount (in a dock or install) to read from another machine, files in system created folders are protected and not available as files in other folders. I learned this the hard way a long time

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

ps, also, if you can't boot computer, remove drive and mount (in a dock or install) to read from another machine, files in system created folders are protected and not available as files in other folders. I learned this the hard way a long time ago ~crystal

On 9/11/2024 10:26 AM, crystal (strive4peace) via groups.io wrote:

hi Doyce,

in my opinion, it is best to avoid using the system created folders. They behave differently than folders you create yourself. I make a root folder called DATA (all caps so it is easy to see) and then hang everything below that.

kind regards,
crystal

On 9/11/2024 9:59 AM, Doyce Winberry via groups.io wrote:

Duane and Jane,

 

Thanks for responding. I didn't get Jane's response but I'm glad Duane included it.

 

The document is saved in the user's documents folder. However the article perfectly describes the issue. I'm checking now to see if that patch has caused the problem. 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, September 11, 2024 9:50 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Error 2302

 

Good to see a question posted to the group (as well as quality answers). You might want to check https: //www. accessforever. org/search?q=PDF Duane Hookom Sent from my mobile On Sep 11, 2024, at 8: 16 AM, Jane <jcross@ crossproducts. plus. com>

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

Good to see a question posted to the group (as well as quality answers). 

 

You might want to check https://www.accessforever.org/search?q=PDF

 

Duane Hookom

 

Sent from my mobile

On Sep 11, 2024, at 8:16 AM, Jane <jcross@crossproducts.plus.com> wrote:



I agree with Mark. It'll be a Windows Update. More & more of my time seems to be spent working around new updates, especially for users with a 365 subscription.

Where is the temp pdf being saved? If it's in the root of c:\ you may find that the windows user profile won't let you delete it anymore.  So a change to a user folder may be a work around.

Best regards

Jane

 

=========================

original question:

I have some automated procedures that send out reports via email. This procedure has worked well for over 15 years. Suddenly last week, I started getting this error: 2302 Microsoft Access can't save the output data to the file you've selected. The procedure creates a report.PDF temp file that used to go away after the procedure ran. Now it appears the file has some kind of lock on it and it can't be deleted. If the server or PC that Access is running on is rebooted, the file disappears and the procedure will run one time but the next time the procedure runs, it gives the error. Anyone have any ideas how to fix this? I can't reboot the server after every procedure and I don't know what has changed. I thought it might be related to the windows user profile so deleted the profile and recreated it but still got the error.  

 

Doyce Winberry