• Thanks.

    ==> If you are seeing the tables as read-only, chances are your userID in SQL Server doesn't have permissions to edit or append data.

    But there is no problem for me to get to SQL Server through current Acces front end. May be there is something that I need to change on the Access side? permissions on each table, or else? Please give me more practical details

    ===========

    ==> And regarding the shared front-end, that is generally considered dangerous. We always deploy the front-end to the user PC - that way if the front-end is somehow corrupted, we can simply replace the one on the PC.

    Yes. That's what we found as well. Or create folders for each user (we have only 4, but all of them are VIPs, e.g. hysterical 🙂 on the share drive so they could enjoy there own file - in this case we do not need to go to each computer: just substitue old files with a new one

    Thanks again