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> 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

Re: [MSAccessProfessionals] Error 2302

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

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116630) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Error 2302

Check to see what MS Windows and/or office service patched have been recently applied - especially those related to the filesystem and/or security.

They would be the first candidates to be reversed to see if they are the root cause of the issue. Long-term stable running code doesn't start throwing errors and weird behavior out of the blue. Recent updates are your most likely culprits - MS seems to have forgotten about anything resembling real, actual QA testing anymore. Instead, they are relying too much on their automated testing suites that don't actually exercise a BUNCH of APIs that application typically DO use - and in ways that the testing scripts don't use them.

This has become the new "same-old; same-old" from Microsoft anymore.

 

On 09/10/2024 2:42 PM EDT Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:

 

 

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

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

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

 

[MSAccessProfessionals] Error 2302

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

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

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

 

Re: [MSAccessProfessionals] Form question

I would open the form's recordsource in datasheet view to determine if records can be added. Then check the form's data properties. 

Duane 

Sent from my mobile

On Jul 2, 2024, at 3:17 PM, bbdkthomas <dthomas@argraffcorp.com> wrote:

I have a form that all of a sudden will not allow me to enter data into a field.

Re: [MSAccessProfessionals] Form question

Check for possibilities of record locking.

If there is any possibility that the same table and data record is open and locked elsewhere in your application, this would be a normal symptom for that.

 

Check all open recordsets, forms/reports, queries, etc. for the possibility of having the same data row(s) open elsewhere and if there are pending writes, then when the focus shifts from that form check to see if there are pending data writes for the form by:

if me.dirty then... logic.

 

I will often fix this by putting:

if me.dirty then runcommand accmdsaverecord

in where the form can lose (mouse-/cursor-)focus/

 

This can prevent the record locks from causing this sort of problem.

i just helped another developer find this exact case arising in a database app on my recent project.

 

- Mark Burns

 

On 07/02/2024 4:16 PM EDT bbdkthomas <dthomas@argraffcorp.com> wrote:

 

 

I have a form that all of a sudden will not allow me to enter data into a field.

[MSAccessProfessionals] Form question

I have a form that all of a sudden will not allow me to enter data into a field.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116625) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_