Search results

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.

Hi George, Thanks for the concern. The issue is not related to a connection string, although it was the connection string that let me know I had a problem.

Hey Guy, Hope you all are doing well and possibly help me with this conundrum. This may not be the best place to ask this question but thought I would start here. I have SQL Server Express and Developer Edition installed on my Machine. I do not have any problem connecting to either Server...

Thanks for the input. Not applicable to this issue.

I though SharePoint was the culprit in this case. I thought I rulled out but I have been through so much other work that I forgot the actual test steps that I had taken to rule it out.

There is no corruption. I even tested this on two very simple databases. Same issue. But I am down to the version of the database, whether it was upgraded from previous versions or created in the current version.

Hi Doc, I initially thought we were onto something here with your insight into the resource manager... I reviewed the Resource Monitor, and I did see a process unrelated to Access but is part of the SysMain Service that controls restricted folders. My search started with "SuperFetch" that...

I had already gone through all those steps. The background process or service that I am referring to would be unrelated to Access. I have even seen where proactive anti-virus cause issues in the past, but I did rule that out. When I said that I tested on more than one machine, I had copied the...

Understood. I did search for a possible solution before creating the thread. Most of what you and others have mentioned here I had found on earlier threads. I do appreciate it though.

I have a feeling the issue is related to a background process, not an access application, but a background process running at the OS level, as a Service or Task. Investigating.

There are no open background processes. I open the DB's from scratch. I even rebooted my PC. I have already built a bulk selectable export feature. I typically do not use any gifted, purchased, or otherwise 3rd party tools, as I am a developer myself. I have been in this business for over 30...