Sharepoint split Access database

[JamesN]

Hi,

I've set up a multi user split access database. Users will be opening the database on sharepoint and submitting records via the front end form. Within the database file the main data table is stored which is being updated.

Is it possible to hide this table without affecting the users from adding records? When i tried hiding it, this resulted in errors when trying to add the record. Or is there any way to set permissions so that new records can be added but existing ones can't be deleted or amended?

Thanks in advance

James

 

[GohDiamond]

Yes, using a form for the interface with the table, DataEntry = Yes, Allow Additions = Yes, Allow Deletions = NO, Allow Edits = No

CHeers!
Goh

 

[JamesN]

Thanks for the solution. Do i update the below in the form properties on the front end form? I updated this and saved the changes but it was still letting me edit the linked table?

 

[GohDiamond]

Yes, on the FE form. Only the designated Database Administrator should ever work directly in the tables of a shared database. Every other user should only be able to see data thru forms, even forms that appear as datasheets, because you cannot apply the limits to the table itself, as far as I know.

That is simply a training issue for the Database users and relatively easy to solve.

But if your users can't be trusted to follow the training, then you're getting into rolling you own User-Level Security Protocols in the database which can be a daunting task, (not impossible, but it's advanced level programming).

You can disallow the datasheet view of a Splitform if it is a problem and force the users to view and work on 1 record at a time. Set Splitform Datasheet to READ ONLY.

Cheers
Goh