Help: Access 2010 Security

[blackknight]

---

mga master, naa ba way para ma secure ang mga table sa access 2010. currently, ang amo problema ky amo database naa sa shared drive nya tanan maka access, every now and then, naa cge pang delete ug mga data na wala mi kahibaw kinsa. nahan unta mi mkahibaw kinsa like everytime e-access nla ang database, ma record ang date, time, username and kung unsa ila gibuhat sa table or the database itself. or maski ang date, time and username when gi access ang database. hope naa maka tabang.

[papasilo]

mga master, naa ba way para ma secure ang mga table sa access 2010. currently, ang amo problema ky amo database naa sa shared drive nya tanan maka access, every now and then, naa cge pang delete ug mga data na wala mi kahibaw kinsa. nahan unta mi mkahibaw kinsa like everytime e-access nla ang database, ma record ang date, time, username and kung unsa ila gibuhat sa table or the database itself. or maski ang date, time and username when gi access ang database. hope naa maka tabang.

Access Boi here, akong g buhat ana bossing is:
-Use a by-pass code. (Disable Shift+Enter) DB side and App side (Preferred to use)

'---------------------------------------------------------------------'
' Module: DisableShiftKey '
' Date: July 18, 2003 '
' '
' Purpose: To stop the user from holding the shift key on startup to '
' access the database window. '
'---------------------------------------------------------------------'

Option Compare Database
Option Explicit
'----------------------------------------------------------------------

Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer
Dim dbs As Object, prp As Variant
Const conPropNotFoundError = 3270

Set dbs = CurrentDb
On Error GoTo Change_Err
dbs.Properties(strPropName) = varPropValue
ChangeProperty = True

Change_Bye:
Exit Function

Change_Err:
If Err = conPropNotFoundError Then ' Property not found.
Set prp = dbs.CreateProperty(strPropName, _
varPropType, varPropValue)
dbs.Properties.Append prp
Resume Next
Else
' Unknown error.
ChangeProperty = False
Resume Change_Bye
End If
End Function
'----------------------------------------------------------------------

Function BypassKey(onoff As Boolean)
Const DB_Boolean As Long = 1
ChangeProperty "AllowBypassKey", DB_Boolean, onoff
End Function
'-----------------------------------------------------------------------

Wala nay timestamp bossing if mo direct delete ka sa database through opening .mdb or .accdb file.

Buhaton nimo ana bossing. on your first open form e onload nimo ang BypassKey = FALSE. For enabling the bypassmode, create a 'hidden' or 'secret' textbox where in you can type the password of your bypass... If password = true then Bypasskey = TRUE, then close the app then open the app using SHIFT+ENTER bypass.

Kanang mag record ka kinsa nag use sa system (CRUD) sa mga data. hardcoded na boss.. so everything before sila mo execute og CRUD statement butangan nimo og code na mo record kinsa na current user ni open sa data any (CRUD) function then record nimo og separate table.

Table: Security_tbl
Username, TableName, FormName, Function(CRUD), Timestamp

[blackknight]

salamat sa pag reply boss....medyo nosebleed, bag-o pa man gud ko aning MS Access. ang blema ani boss ky murag directly cya mo delete sa mga data by accessing/opening the table itself. as of the moment, wala mi gagamit ug any forms to put records in our database, direct mi mo input ug mga records sa database or thru excel macro.

- - - Updated - - -

and if mo butang mi ug password sa amo database, we will have to redo all our excel macro para ma bypass nya ang password (sakto ba ko?)

[papasilo]

salamat sa pag reply boss....medyo nosebleed, bag-o pa man gud ko aning MS Access. ang blema ani boss ky murag directly cya mo delete sa mga data by accessing/opening the table itself. as of the moment, wala mi gagamit ug any forms to put records in our database, direct mi mo input ug mga records sa database or thru excel macro.

- - - Updated - - -

and if mo butang mi ug password sa amo database, we will have to redo all our excel macro para ma bypass nya ang password (sakto ba ko?)

Ahhhhh........ So wala forms? kana lisod na siya boss. dapat gyud na siya buhatan nimo og forms. so you can
add security features/user rights. Kay kung mag direct encode man gud ka sa tables. actually mura raka nag excel, there's no limitation.. users can easily delete or update records without noticing it.

Better gyud ani niya boss.. you will create a form with a SUBFORM viewed as Datasheet. on your Parent Form. Adto nimo e butang ang CRUD Buttons. Create ka og function (ONLOAD) check unsa ang rights sa user currently login. ... blah2.. Basin mo dugo imong nose nsad.. ingna lang ko kung interested ka, willing to teach this holiday season :3 next year pa balik work WOOOHHOOO!!

Okay ra ko og hilason na kape boss (STARBUX) haha.. bitaw PM me if you're interested.

or

Try lang research about Workgroup Administrator (2003) murag naa sad ni siya sa 2010. d kayu ko sure pero murag ma limit nimo ang CRUD sa table using this. Research lang about ani.

[blackknight]

cge cge boss...salamat kaayo. maayo paka next year paka balik work....pm lang tika kung makalugar ko....