ACCESS FEED

Kamis, 10 Oktober 2024

Re: [MSAccessProfessionals] Invalid Procedure Call error

Duane,

242 characters with spaces

Jim Wagner

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Thursday, October 10, 2024 8:50 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Invalid Procedure Call error

Thank You Duane. I will look

Jim Wagner

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom <duanehookom@hotmail.com>
Sent: Thursday, October 10, 2024 7:26 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Invalid Procedure Call error

I would first look at the number of characters in Paragraph2 to make sure it's more than 554 characters.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Thursday, October 10, 2024 8:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Invalid Procedure Call error

Hello All,

Yesterday I started to get an error message for "Invalid Procedure call" when I tried to open a report. This report has been running for years with no issues. This morning after several hours, I deleted from the query this line

MemoWithDate: Left([tblMaxCompensatoryMemo].[Paragraph2],Len([tblMaxCompensatoryMemo].[Paragraph2])-554)

and the query ran successfully with no issues. So, I am assuming that either an office update or something is haywire with the database has recently occurred. I have checked vba references and there are no missing references.

I am not sure where to go from here. Can someone help me find a solution. My user is to the point of extreme frustration with me.

Thank You

Jim Wagner

Re: [MSAccessProfessionals] Invalid Procedure Call error

Thank You Duane. I will look

Jim Wagner

I would first look at the number of characters in Paragraph2 to make sure it's more than 554 characters.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Thursday, October 10, 2024 8:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Invalid Procedure Call error

Hello All,

MemoWithDate: Left([tblMaxCompensatoryMemo].[Paragraph2],Len([tblMaxCompensatoryMemo].[Paragraph2])-554)

I am not sure where to go from here. Can someone help me find a solution. My user is to the point of extreme frustration with me.

Thank You

Jim Wagner

Re: [MSAccessProfessionals] Invalid Procedure Call error

I would first look at the number of characters in Paragraph2 to make sure it's more than 554 characters.

Duane

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Thursday, October 10, 2024 8:40 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Invalid Procedure Call error

Hello All,

MemoWithDate: Left([tblMaxCompensatoryMemo].[Paragraph2],Len([tblMaxCompensatoryMemo].[Paragraph2])-554)

I am not sure where to go from here. Can someone help me find a solution. My user is to the point of extreme frustration with me.

Thank You

Jim Wagner

[MSAccessProfessionals] Invalid Procedure Call error

Hello All,

MemoWithDate: Left([tblMaxCompensatoryMemo].[Paragraph2],Len([tblMaxCompensatoryMemo].[Paragraph2])-554)

I am not sure where to go from here. Can someone help me find a solution. My user is to the point of extreme frustration with me.

Thank You

Jim Wagner

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Rabu, 11 September 2024

Re: [MSAccessProfessionals] Error 2302

Some good news for the group. My issue has been solved by doing an online Office 365 Repair.

Thanks to everyone who responded. It was nice to see Bill's, Crystal's and Duane's names in my email again. Hope you all are doing well.

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 3:41 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Error 2302

OT, Duane, lol about Rules. I have all messages from this forum sent to a specified folder -- but not all make it ;) kind regards, crystal On 9/11/2024 1: 57 PM, Duane Hookom wrote: Everyone may need to check their junk/spam folders for these

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

OT, Duane, lol about Rules. I have all messages from this forum sent to a specified folder -- but not all make it ;)

kind regards,
crystal

On 9/11/2024 1:57 PM, Duane Hookom wrote:

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

Re: [MSAccessProfessionals] Error 2302

OT, Duane, lol about Rules. I have all messages from this forum sent to a specified folder -- but not all make it ;)

kind regards,
crystal

On 9/11/2024 1:57 PM, Duane Hookom wrote:

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

Re: [MSAccessProfessionals] Error 2302

That has happened to me several times. My email host seems to think our group is spam. If you have this problem, sign on directly to your email account and mark groups.io emails as "not spam".

Regards,

Bill Mosca

From: MSAccessProfessionals@groupsio <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Wednesday, September 11, 2024 2:58:24 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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