Search results

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.

If the Subform is already bound to the Job Description Table, why not make the Control source of the Combo Box to the respective Field? Rather than having to write code to perform the update, just place a Me.Refresh in the AfterUpdate event and be done with it!

When you view the records, are you looking at them from Access or SSMS? Access does not understand the TIMESTAMP Data Type. It will show as empty from Access. It is not a Timestamp, as in Date and Time, but is used for Row Versioning. If you have used SSMA to migrate your Data, which I believe...

Sorry for the delayed response... super busy. Yes, I understand that (some) ActiveX controls are not compatible with 64-bit Access. I say some because the Tree Control is. Anyway, the issues was while trying to delete them. I just could not delete them. I would select the control and press...

The Client does not want to uninstall O-64 for O-32. already suggested that. There is a 3rd party ActiveX Control, its TLB and DLL that will not install. It requires a Password and the original company that developed the application has gone out of business. The Company that purchased it will...

Hi All, I have a weird conundrum that I have never encountered before. I am hopng that one of you may have some experience with this and what your solution was. I have a client that has upgraded several Computers and M365 Office to 64-bit. They have a legacy application that began in Access...

After further review and testing, I believe this is the issue. Thanks!

I have pretty much narrowed it down to Databases that are connected to SharePoint. Apparently SP places some type of security restriction on the Application. This may be controlled by the data governance section of SP and the specific Site. Thanks for your help!

Unfortunately, that is not the issue. It is related to a technical issue with the way the DB is configured, just have not been able to put a finger on it yet. Even when I reboot my PC and start from scratch and open the DB's holding down the shift key to bypass startup code, I still cannot copy...

I had updated the OP with this information.... That said, the issue is 97% resolved. There are two Servers. The Express was using 1433 and is the default server. If a second Server is installed, if the Port is omitted, as was in this case, it defaults to 1433 and therefore connects to the...

Hi Arnel, Thanks for the insight, but unrelated.