S
spburke
I have an upsized database on MDSE. The problem I am having is that I can
connect using my local network credentials and fully modify the data through
access. When I create any sql account to connect via odbc I can view the
data in the linked tables but not edit or delete, regardless of credentials
(db_owner) for the account. Even connecting via sa does not permit
edits/deletes. The server was installed to allow sql or windows
authentication. Any idea what is causing this? Thank you!
connect using my local network credentials and fully modify the data through
access. When I create any sql account to connect via odbc I can view the
data in the linked tables but not edit or delete, regardless of credentials
(db_owner) for the account. Even connecting via sa does not permit
edits/deletes. The server was installed to allow sql or windows
authentication. Any idea what is causing this? Thank you!