I am using SQL 2012 I will try the suggestion thank you.

I will try it tonight when no one is logged in

Steve

When I imported the Access tables

A Colum was added to each table called "SSMA_TimeStamp" it is a "timestamp" type with Allow nulls as un ticked.

but the problem was still...

I have a solution though

I have a table with each user stored password and security i.e. what options are available.

To this I have added a "record open field".

As each record...

Hi I do have 5 Bit Fields none have Null values all are either 0 or -1

Nulls are allowed but when I try to change to not allowed I get...