Recent content by Marshall Brooks

@jdraw - Forgot to thank you again for your help with the data macros!!!

@jdraw - For the most part, yes. We wanted the DM's as a tracker for who changed what and when and they work fantastically for that. Only slight problem is the users sometimes click something by accident or forget to send it on and click it again and the DM (correctly) records that the field was...

Glad it worked and glad I could finally give back a bit instead of always asking<begging ...>

It works. Been a while since I set it up, but we are split db/Multiuser and it works fine. Might have issues if you don't have unique usernames and or nobody has to log onto the PC with the FE, but it works otherwise. Reply back if you need more details.

@NauticalGent - Yes, you can - it's essentially on the last page of your attachment. Basically, you add a field for UserName to your AuditLog table (not the table being audited). Or did I misunderstand the question?

Waiting to hear back from my users. I know in the past, I've done the same thing and not had the sluggishness I initially reported. And our local users, didn't report it, only the Citrix users. And what I did earlier probably would NOT fix it from what @NauticalGent says - i.e. I ran the...

At this point, I'm not sure if it was the Powershell script or the Trusted Publishers update. Apparently, both were done before I re-tested.

Something happened, b/c this database was never on the internet nor sent via E_mail, but running the PowerShell script resolved the issue.

@isladogs - We distribute via a network drive. I never saw the Unblock text or checkbox under Properties - even when I was having the issue, but I ran the Powershell script and it seems to have fixed the issue (for me, at least). I ran the unblock on my shared folder and then copied it to the...

MOTW was apparently the issue. I was skeptical b/c I didn't see an Unblock option on the Properties menu, and the Powershell script didn't give any confirmation, but I ran it and everything seems to be working okay. I only ran it on the FE, but that seems to have worked. Question: If I run the...

No and that seems likely to be the issue. From the Front-end or the back end or both? And how do I do that? I was having issues with Excel files also and it ended up being an issue with having protected view enabled, but one suggestion was copying to a local folder and checking unblock. The...

@isladogs - Thank you. That SOUNDS like it could be the issue, but there are some significant differences in my case. First off, in the trust center>Macro settings, by default we are using this option: "Disable all macros with notification." I think we have the ability to change it to enable...

Follow-up. It seems to be mainly my VBA code that is running slowly. I'm guessing this is more likely related to Office 365 than Server 2022. I tried to compare between my local and Citrix settings, but is there something besides Trusted Locations that would slow down VBA code?

Citrix admins have not changed. They do admit that they don't know anything about Access and its set up. See above for Windows and Office Versions. Citrix was using Server 2016 and Office 2016 and was fast. Citrix is now using Server 2022 and Office 365 (and different virtual servers) and is...

Basically, I stopped using VPN - for speed reasons rather then potential corruption, but I understand your point. I used Citrix when I was working remote b/c it was faster. It still is for queries and record access, but it no longer is for my VBA code.