I've been tasked with troubleshooting a problem for a client that is having trouble with a procedure created by someone who recently passed away. Unfortunately, this person's computing knowledge is much greater than mine and there wasn't much documentation created on the procedure. But I believe I have narrowed down the issue to this:
An application has its database linked to sql server 2008. When I create a new record in this application, I can see the new record in sql server. However, If I edit any record (or delete a record) in this application, the changes are not reflected in the sql database. Conversely, if I create, edit, or delete a record in sql server, the changes aren't reflected in the external application.
Research has told me I should be looking into sql database permissions or ODBC settings but with a beginner's level of experience with both, I haven't been able to come up with a solution yet.