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!