Solved While splitting Microsoft Access BE file an error accrued "The search key was not found in any record."

[Khurramshaikh47]

Hi,
I am trying to share my database in my Local Area Network. When I am trying to split my database an error appears "The search key was not found in any record.".
Please guide me on how to resolve this issue. And share my database so my colleagues also can use that.

Thank you

 

[arnelgp]

try to compile your VBA and see if you can find any error while it compiles.
if there is, rectify it first before splitting.

 

[isladogs]

That error usually indicates the data is corrupted

 

[Khurramshaikh47]

try to compile your VBA and see if you can find any error while it compiles.
if there is, rectify it first before splitting.

No issues were found in the VBA codes.

 

[Khurramshaikh47]

That error usually indicates the data is corrupted

Yes, some data was corrupted.

 

[Khurramshaikh47]

I've created a new blank DB and copied the tables only and then made be file and then copy all other objects and then made its ACCDE file. Now it's shared.

Thank you

 

[isladogs]