FoFa
Registered User.
- Local time
- Today, 17:25
- Joined
- Jan 29, 2003
- Messages
- 3,672
SQL server 2008, ODBC connection.
Both DEV. and PROD same.
DEV. can update a view via open it (forms based off the view) and update in form, etc.
PROD, won't allow updates either in the form or opening the view directly.
View permissions are the same on SQL both DEV and PROD.
Delinked and relinked many times.
Via SQL query using the same ID access uses can issue an UPDATE sql, works fine.
PROD can open the table the view is based off of, and can update in both DEV and PROD.
I know I am just missing something, just can't put my finger on it.
DEV. and PROD seem the same.
Ideas?
Both DEV. and PROD same.
DEV. can update a view via open it (forms based off the view) and update in form, etc.
PROD, won't allow updates either in the form or opening the view directly.
View permissions are the same on SQL both DEV and PROD.
Delinked and relinked many times.
Via SQL query using the same ID access uses can issue an UPDATE sql, works fine.
PROD can open the table the view is based off of, and can update in both DEV and PROD.
I know I am just missing something, just can't put my finger on it.
DEV. and PROD seem the same.
Ideas?