Access 2007 & Domains

[tcheck]

I use to build Access 2000 and > with Workgroup authority on what users could and could not see and View, Edit and Delete in the database. Microsoft does not have Workgroup authority any longer unless I dumb the database down to an MDB (as far as I can tell). I would like to use the Network domain and domain groups to allow users to View, Modify and Delete information in Access 2007 and I have not found much information on the web about this.
Can anyone point me in the correct direction?

[pbaldy]

My friend Tom has code and a sample db here that might help:

http://www.accesssecurityblog.com/

[tcheck]

Thank you, this looks exactly what I am looking for. I appreciate it and I will let you know my status on the project.

[pbaldy]

No problem, I hope it helps.

[tcheck]

I am starting to write the code to make the Access database Security based on AD and I have a quick question. I am not an expert coder and in a blog I found the following that I am not sure how to accomplish, it is;

Code Reference

To start using the sample code in the attached project, copy these modules to your application: modAPI, modSecurity, and modUtilities. Also set a reference (code window > Tools > References) to "Active DS Type Library" (activeds.tlb). Choose Debug > Compile to make sure the code compiles.
modSecurity has several public functions that are used to apply security. The first one we already briefly saw in action above:

Any help would be appreciated

[RuralGuy]

Paul must still be sleeping but maybe I can help. What part of what you just described do you not understand?

[tcheck]

Thanks.

How do I get the references into the database? Where do I get them?

To start using the sample code in the attached project, copy these modules to your application: modAPI, modSecurity, and modUtilities. Also set a reference (code window > Tools > References) to "Active DS Type Library" (activeds.tlb). Choose Debug > Compile to make sure the code compiles.

[RuralGuy]

Did you import the modules into your application? While viewing the code did you then go to Tools>References and scroll down and see if Active DS Type Library was there and check it?

[tcheck]

I'm sorry, is it on the web page? I do not see it.

[tcheck]

Thanks Rg. I noticed the downloadable zip file in the post, downoaded it, found the mods and imported them into my database and went into VB and found the refernces.

Thanks again.

[tcheck]

I am compiling the database and I am attempting to put in an audit trail that tells the database who updated a table. It works fine in my form, but when I compile the code I get an on

Private Sub Form_AfterUpdate()
Me.Updatedby = fOSUserName
End Sub

It states Ambiguous name detected: fOUsername

[RuralGuy]

fOUsername is not an Access intrinsic function. It would need to be created in a standard module.

[pbaldy]

If it's saying ambiguous name, make sure the module isn't named the same as the function.

I was definitely sleeping earlier!

[RuralGuy]

If it's saying ambiguous name, make sure the module isn't named the same as the function.

I was definitely sleeping earlier!

You hit the nailn the head Paul and good morning sunshine!

[pbaldy]

<insert yawn here>

<insert stretch here>

Ah, do I have to get up already?!?