Please help! I have created a sql server 2000 database and added a sql database as an front-end application. Using access as front-end, i can create a new record successfully however, i can not EDIT any fields in the record after i create it. I receive an error indicating that someone else is in the table and i can not edit the information. I know its something with Access because i linked an ASP page to the databse and created a record and edited with no trouble. Do guys know what might be causing th is? I am using windows authentication and the users have adequate permissions to read and write to the database.
Also, issue#2, some users, all have same permissions, can access the queries on the databse and the others are receiving an ODBC connection error. Again, all have same permissions. Please help!
Also, issue#2, some users, all have same permissions, can access the queries on the databse and the others are receiving an ODBC connection error. Again, all have same permissions. Please help!
