Re: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.

If you cannot delete the record its a sure sign of corruption. Create new db and import all objects.

On Thu, Apr 8, 2021, 1:39 PM Arnelito Puzon <agpuzon@gmail.com> wrote:

You should have asked the user what is the last he do, what report.

Maybe you can debug the report and inspect each variable values.

On Thu, Apr 8, 2021, 6:48 AM Jim Wagner <josephwagner2@outlook.com> wrote:

Duane,

You were right. It was a bad record. there was a record with Chinese characters. I could not directly delete the record. I had to use a make table query to exclude the record. that finally worked. but deleting it directly would give me an error saying it could not find the key. 

thank you for your help. 

Jim Wagner

---

From: Jim Wagner <josephwagner2@outlook.com>
Sent: Wednesday, April 7, 2021 2:37 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.

 

Thank You Duane. 

the report has been working for years and there has been no changes to the query or the report. 

No missing references in vba

I did not create the table so the names are so crazy that I cringe every time i see them.  examples Draft posting to HO and HO approves posting

The query runs with no issues. 

I deleted all of the objects on the report and that did not work. 

I  deleted the text box in the grouping header and it worked. 

but when i recreated the report it came back with the error. 

i created a new table and i still see the error

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom <duanehookom@hotmail.com>
Sent: Wednesday, April 7, 2021 2:10 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.

 

Hi Jim,

I did some quick searching and several threads point to corrupt records. Otherwise I would check the References and look for field names using reserved words.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Jim Wagner <josephwagner2@outlook.com>
Sent: Wednesday, April 7, 2021 3:52 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] New Error | Reserved Error (-1524); there is no message for this error.

 

Hello All,

One of my users received this error on a front end database this morning. the help is no help. I am able to recreate the objects of the report and query and table in a blank database and it works. but if I move it into the production front end it does not work. I moved all of the objects to a blank database and that did not work. all of the tables are linked tables in a backend. 
It has taken me years to get my bosses to let me do the front end back end solution and this may force me back to one database for multiple users. 

there was a office update last night so i do not know what to think. 

Is there a fix for this? 

thank You

Jim Wagner

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_