They do not have the Pass-Through button toggled, so I believe they are native Access queries.

I would have to say based on my testing that I disagree with the premise in those links. As a very simple example, I open up a linked table...

Wow, I never knew this existed. This is very helpful.

Thanks for the replies. In my current system we use this for database consistency checks that we are unable to use hard constraints on. So these emails are...

Sorry, I did forget to include the splitstring function:

CREATE function [dbo].[SplitString]

(

@STR nvarchar(4000),

...

In addition to those already listed by others, I added checks for:

- Disabled Indexes (no way to tell in the GUI that I am aware of)

- Auto Create/Update statistics set...

Your responses make sense, thank you both.

Thank you for the replies.

The refdate field is equal to the crdate field in most, if not all, of the records.

Most of the records are #[eight digit hex], but there...

I've only been in the professional workspace for 5 years now, so I probably don't have the perspective that most of you do. I like the idea of a...