Finally; in the interest of giving back to the community.  If you are interested in how I turned my table spec into a stored procedure - here it is;

I use...

To future readers;

The responses from Phil and Scott helped me solve my problem.  Ultimately, for my use case, I used unique constraints as is specified in my DDL above.  Further...

Scott.  Thanks for the reply.

My reply to Phil gives some more background.  Obsolete dates are being captured correctly.  As far as I know, the Date datatype is sufficient for Effective...

Phil.  Thanks for the reply.

Now I'm 2nd guessing myself about the results I was seeing.  I think it was actually working although the error message was not what I was...

• This reply was modified 4 years, 1 month ago by  CanuckBuck.

Ken;

With regard to creating views;  I have not yet tried that but I suspect it would work.  I had just hoped to avoid going to that additional overhead.

Thanks!

Ken;

I tried what you suggest - using the syntax to create the columns as hidden.  While this does "hide" the columns in a select * from [tablename], by default, (it...

I'm including this for the sake of completing the discussion since I think I've discovered the source of my problem. Using this version of the DDL I was not able...

Steve;

Thanks for the direction.  I didn't include the code in-line initially because it is quite large (almost 1200 lines), and as I think about it now, would probably not run...

Mmm... it appears I am unable to upload either a .sql file or a .accdb file.  How unfortunate.

I tried to recreate the problem with simplified version of the table and...

Wendell;

I too have experienced lost posts on the SSC site over the last while - since they changed the site.

Thanks for the reply.

I'm familiar with indexed views, however, the structure...

Hello Wendell.  Thank you for your response.

Sorry in advance for the lengthy reply.  I don't even know that there's a clue in here...

You are correct that the field in question...

So;

I updated the title using the edit button and now the title is shown correctly but I can not see my original post and I can not see the post...

Thom.

Thanks for the response.

When I used that previously and saved my edit, my entire post simply disappeared - was no longer displayed on the forum listing.  however, from the list...

More apologies.  I see that the title of this post is... vague.  I intended for it to say "MS Access Me.Refresh doesn't work".  Because of the problems I've experienced editing...