Search results

I believe you are replying to me... As I said, I believe the issue is the Analyzer Report. There is no such thing as a hidden index. I cannot find any documentation anywhere on the topic. I believe the developer of the report made some assumptions when creating it, assuming that all FK columns...

I ran your Script George, and I ran one that I have to list All Index, neither show the FK Column as an Indexed Field. I truly think it is a glitch with the Documenter/Analyzer Report and not with Access as a DB itself. Pardon my scribbles.

Okay, I am going to follow these steps. but in a nutshell, when I run the DB documenter Report, this is baffling. I do not think it is a REAL index. I think it was an assumption by the person that developed this report for Access. I created two ID Fields in Table Two. The first is intended to...

I am not the OP, I am a commentor and this is kind of like a sub-thread. Someone referred to SSMA not creating "HIDDEN" Indexes. I did ask about Sql Serve "Full-Text Indexes" because I really did not know what they were, and I think that has already been answered. Not sure why it never...

You can refer to AllTables, AllQueries, AllForms, AllReportss, AllMacros, and AllModules under Application.CurrentProject. You can loop through each one or refer to a specific object by including its optional name, such as Application.CurrentProject.AllForms("ObjectName").IsLoaded and test the...

When I create Tables, I always use Number Fields to relate Tables. Very very seldom if ever will I use a Text Field for a FK. When I create a Number Field, it automatically indexes the column. The Primary Key will also be indexed. I typically always use the Auto-number Type. I never have...

It is in SSMS. I included this because it can generate full Database Scripts, and when you select the Dependent Object option, the Objects will be iterated in the correct order based on hierarchical order of FK's. I use this when the migration end point is an SQL Server DB. I never use SSMA...

There have been a lot of recent updates to SSMA, but I have been using it exclusively for years and have never seen a missed index on a FK, so long as the Index was already defined in the Access Table, regardless if it was used in a FK. The only time I have ever changed any of the Project...

I have never seen or never heard of a hidden index, not in Access, and not in SQL Server.

Understood. Not sure why the never dawned on me. As you can see in this snippet, the Northwind DB that Iused SSMA to create the Tables on SQL Server, that it did fact create the Index on a Foreign Key. "EmployeePrivileges$EmployeesEmployeePrivileges" below is the Index and is the FK for the ID...

I am not sure what a "Hidden Index" is. For the life of me, I have never heard that ever existed and when I do a search on it, all that comes up is related to MongoDb. Can you tell me how they are created and can you provide me a screenshot of a hidden index? Is this possibly what SSMS refers to...

Hi Pat, Not sure what you are talking about. I just used the SSMA and default Settings to generate an SQL Server DB from the Northwind Developer Edition Access Database Template that is available on the Access Backstage. As you can see in this snippet, it does in fact create the Foreign Keys...

Thanks Doc. My question was more for the OP and I hope he reads your response. My experience with Clients that put more trust in the Service Company than the resident SA is that the SA is on the way out the door and doesn't know it yet. But as long as he/she is the SA, then in my mind they are...

I am still stuck on why we would want to block System Administrators. If the System Admin is the SA on the Server, why would we block him? Permissions are hierarchical. Employees at the top generally respect and protect the systems in their control. They know their limitations and respect their...

I have looked at your Database and it is difficult to understand what your goal is. If your [JOD SOP TBL] is to be the source for the Description you do not need Combo boxes. You can have regular Text Boxes bound to the respective Columns to insert Data into the Table. Aside from that, I just...

You said Database, therefore I refer to Database lever permissions. If the System Admins already have Security Admin at the Server Level, there is nothing you can do. The owner and SA of the Server should ALWAYS have access to every Object and Role on the Server.

I have been reading that the datatype would be deprecated as early as 2009. The deprecation as you have indicated is in syntax, as you have indicated, not the underlying mechanism. Even though they advise to stop using it altogether, I cannot see MS stopping support in the mechanism. the impact...

Ah, ok, now I understand the ambiguity. And when i stated that it cannot be applied as a data type, I meant from the SSMS Table Designer. When you do add it from a Query Window, as you have illustrated, it will display Timestamp on the Column in the Designer. ROWVERSION pre-dated Timestamp and...

Hi George, The Timestamp Column might be deprecated but is still in use. You can create a Timestamp Column, but you cannot apply a RowVersion Type. While it may by synonymous, only the Timestamp Data Type can be applied. Yes, as Tom pointed out, but I feel we basically said the same thing in...

Yeah, remove them from any of the Admin Permission Roles.