Reply to point 1.
Are you trying to update/delete RECORDS in the tables or the STRUCTURE of the table itself? If its the latter, you will have to do that in SQL server itself eg in SQL server enterpise manager, not in access (unless you write an access project instead of an access database). If its the former, you definitely have something wrong either in your SQL server user permissions, OR in the way you set up the user code part ( which is easy to get wrong) of the ODBC data source.
Well, I created an ODBC connection on a desktop computer. Opened Access and chose "File, Get External Data, and Link Tables." From the drop-down box, I selected ODBC Connection and chose the one I already created.
Now, I can double click on the linked table and view the data, make forms from the data, and query the data, but I can't make any inserts, updates or deletions from the linked table.
The user that is logged into the local desktop is the same domain user that is Admin on the SQL Server.
I didn't see anything in the properties of the ODBC Connection that looks like it limited the access to the SQL Server.
In the odbc data source is a page in the setup which refers to "How should SQL server verify the authenticity of the logon" , u have various options which r critical in what access you have to the db, if any. I cant give you more info, but you have to have these right, inc items on Client configuration button (i use named pipes here, it worked on our server). Are you SURE you have update permissions set up in sql server for user you are logged in as, and for user it may be getting from the data source, (can have user id embedded in it). It took me some trial and error to make it work. Also you must have, to be able to update records from Access in a linked SQL server table. The table must have a unique primary key in SQL server. Check that you have a unique primary key for ALL the tables. Also, a field defined in an SQL server table with datatype that isnt compatible with Access can cause problems with updating. I have fallen into all of these traps myself before.