After splitting database importing excel files gives error 2950 (1 Viewer)

Before splitting my database I was using a macro for importing excel file to my table and it was okey.
Now after splitting database when I use that macro from front-end I got error
“You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again." The error number on the Macro Single Step pop-up is 2950.

when i use macro from back-end it does not have problem and works.

please help because i need importing from front-end.

This thread although small might help - trusted location issue ? https://access-programmers.co.uk/forums/showthread.php?t=195464