Search results

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

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.