mysql - Linked a SQL to Access, Requery is displaying #Deleted -
i have sql server backend have linked access frontend. deleted table link in access , relinked view displays contents of deleted table on sql side. changed name in access of view name table had code work.
the problem anytime requery called, references old table shows #deleted. i'm thinking code still somehow linked old table, inserting , deleting data through view work i'm not sure. appreciated thanks.
i solved this. being stupid , didn't realize row level security wasn't being implemented till after requery, record getting lost.
Comments
Post a Comment