Also here is the complete table definition.

USE [GKHumanResource]

GO

/****** Object: Table [dbo].[HRCaseData] Script Date: 8/7/2013 3:59:59 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[HRCaseData](

[Id]...

Wendell,

When I made the change to add suser_sname() as the default value for the field it works well only from my system.

If I launch the access file from...

Thanks Wendal.

I like that approach to make the backend do the work. I didn't realize suser_sname() was meant to be put in the table definition which is why I...

Yes!!!

That will suffice. Thank you so much!!!!!!

It Works!

Public Function GetWindowUser() as String

GetWindowUser = Environ("USERNAME")

End Function

Mr Brush,

The line of code is definitely not executing.

I added break on all errors and the vb editor doesn't pop up.

Also if I set the default value...

The correct column is picked therefore I don't believe that is the issue.

What else could I be missing?

No problem Mr. Brush. I picked up on that syntax.

I put the break point in and it isn't being touched.

The OnError Resume Next was put in by access. Its...

I put the line of code in but it isn't updating the field and seems to have prevented record navigation command buttons.

Did I place the line you recommended in...

Thanks for the suggestions but I have not been successful.

I used Environ("UserName"), suser_sname(), and select system_user to populate the value in the text box on the form.

I am...

Got it. So keeping a good practice of baseline measurements is essential for this measurement to be effective at identifying anomaly's.

Thanks Gila!

I have used the GNU for windows version and figured out what I need with the exception of encrypt and sign multiple files.

I have a directory which will contain...

Joe,

You asked?

I did a little bit of research...

OPC,

When I tested it at the SQL level I was logging into the sql server as the user in the limitedlogins table.

At the application level I would receive...

How can the login fail for user SA?

The only place I am entering the SA credentials are in the connection manager to test my data data connection.

Ok well I was able to get it to work.

In Flat File Connection Manager Editor, Under General, I set the Format to Ragged Right and Header Row Delimeter to...