Recent content by spaLOGICng

Thanks for your input. Yes, and that is one of the most common causes. It is important to clean up VBA Record Set Activity as well, like closing Recordsets and Databases, otherwise they will hang, too. How that was not the instance in this case. It is caused by a live connection on a Table(s)...

I was beginning to like you Pat. My apology for going off on a tangent but I am not the one that brought up SSMA or Hidden Indexes to begin with. Sometimes I need to dispute things in a way where I will be corrected. Notwithstanding, I was merely showing the Auto-index feature as part of my...

By default, Access will create an Index on any begins or ends with any of the names in the auto-index box as seen here. As to why they were not created automatically in the OP's database, I am not sure, unless the tag words were changed or removed. It should have automatically created indexes...

Are you referring to the purple line references here? It actually does not list the Field name. Apart from that, the FK Column Name is "Tbl1_ID", not TestID. Once again, and for the record, Access will be default automatically create indexes for columns that begin with or end with certain...

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...