Search results

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

Hi Tom, I have seen this issue as well. Where, for instance, and DAO Record Set was not closed and would orphan the DB in an open state. That is not the case here. I did check for that. I compacted and repaired both DB's, then re-opened from a clean slate holding down the shift key to bypass...

Hi Doc, I believe this is a technical issue not related to the conventional or typical causes for this error. I have been working like this for a long time, and only recently ran into the issue. Nothing has changed except for updates to Windows and Office.

I have full control of all Files and Folders. I am the Owner and Administrator of all my machines and not attached to any Domain Controller. I do have UAC enabled but I do not get the UAC permission window when I install programs etc. Interestingly enough, I looked at my Local Folder...

The database has been placed in a state by a user on a machine that prevents it from being opened or locked (Error 3734) I have a client that likes to make changes to his version of the application. I maintain the developer master copy and so I need to merge his changes, etc., with my copy and...

A CSV File is technically a Text File. Once it is opened in Excel, the Long Numbers are destroyed and converted to exponentials. I always stress to clients to NEVER open a CSV file in excel before it is imported. If it is converted, you can use VBA to first open it in Excel and TRIM() the...

Yes, I corrected myself in my most recent comment just two responses above yours, once I read about the security requirements. I, like you, would use as much of the built-in objects as possible. In my corrected statement, I mentioned using the ObjectID of the Table rather than the name, in the...

You can build off of the existing Access information that is already built-in. Why build it again! You can create an INSERT Query based on the MSysObject and be done with it. You can join your Obejct Table to the MSysObject Table to remove Objects that you have already inserted into you table...

Why is it necessary to do this? There is already a hidden table in Access that already maintains this information. What you are doing is redundant and a waste of precious space in the database. Unless you are doing this for educational purposes and training exercises working with Recordsets, I...

There is no need to reopen the form when the Record is saved. In the underlying record source to the Form, simply filter out those records that are in use. When the User on other FE's click the save but, simply requery the form, or apply a new filter. A lot of resources are wasted to close and...

Hmm... CTL+A then CTL+- ... this catastrophic as it will delete all records. Also, selecting individual records from the record selectors on the left then clicking right mouse will also permit record deletion. No programming required to delete records.