@dashrender You can create (on the EAC side) three options. Dynamic Distribution, Distribution, or Security.
I've nested the Dynamics into the Security, because you can't add dynamics to a permissions list, as you've outlined you are aware of. However, "pure security groups" might be the issue. As I suspect permissions are not going to propegate through a security group and it's nested non-security groups like I would like them to.
@dashrender Do you think that because the security group is populated by several dynamic distribution groups that it wouldn't work?
I could just add everyone individually to the security group, but I like to do dynamic groups based on AD departments because it makes things easier for the onboarding/offboarding part of things.
On-Prem Exchange
Outlook 2019
Okay so because we need everyone in the organization to see this shared calendar, and we can't add each person because you can't add that many people (I think it's somewhere in the ballpark of 64 max) I've been trying to figure out how to make it work/best practices.
After a bit of reading, I've created mail-enable Dynamic Distribution groups (via EAC) based on the "Department" field in the Organization tab of User>Properties in AD. I know these work, as I've been using them.
But, since you can't add dynamic distribution groups to the permissions list for calendars, I've created a mail-enable security group (via EAC) and put them all in it.
However, I can't get it to work. Users are able to pull the calendar up, but it just says "failed to update" above it, and I'm guessing it's a permissions issue.
Current permissions on each Distibution group:
Membership>Members: All Recipient Types (after "Only the following: Users with Exchange mailboxes" didn't work.)
Rule>Recipient Container: Domain (contoso.com)
Rule>Department: listed department names from the department fields in AD ("Registrar" etc.)
Any ideas?
EDIT: I'm clearly having a moment. So there's this little group called "Default" that's basically everyone, so I was able to set Reviewer to that group and now everyone can see the calendar. ::facepalm::
I'd still like to know how I could make my initial approach work, if possible.
I made the point to our Logistics department that my office spends the majority of our work day at our desks, and that our chairs are ironically the most basic in the building.
He heard me and agreed to humor a request.
Any go-to brands/models you all would suggest? I've been told to pick from rogards.com.
LOL. Maybe even in something other than Access!
I talked to the boss and he agreed to moving to a SQL Server. Now I'm researching a frontend for it.
What kind of data is it? Any why does no one else need access to it?
It's funny that you ask that, as I'm being told we kept it as a "convenience for the Registrar department". smh.
Still, the other broadly used database (64-bit) isn't written by us, and lacks some functionality the Registrar Dept. requires. I guess it's time to have a serious discussion with people above me.
Is it ironic that an application called Access is the tool that blocks access?
LOL, yes. Yes it is.
Do you have access to the pre-compiled version of your access file?
I think it was made in the mid-90's. My guess is no, but I'm going to ask my boss. Is that a necessity?
If the data matters, they need to move to something practical and business class.
I'm with you 100%.
@scottalanmiller said in Taking suggestions about x86 Access replacement:
I've not looked into this in forever, but is there no update process to Access DB files?
I was mistaken and it is .accde which changes things.
Currently reading this article and it looks like I need to know more about how this was built before I will really know if it's possible. Conversion doesn't look simple.
https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/
@jasgot said in Taking suggestions about x86 Access replacement:
@mr-jones Can you tell us why they need 32 bit? We manage a ton of Access databases that were created and developed under 32 bit MS Access in the year 2003. With very little effort, these are all running just ducky under 64bit Access 2019.
I'm just curious if you may be having a problem that is simple to resolve, but since everyone has always said it has to be 32, the solution hasn't been explored....
Do you mind expanding on the "with very little effort" part? I'd like to know what that effort was. As it stands, when you try to open 32 bit with 64 bit Office, it flags an error of "This database was created with a 32-bit version of Microsoft Access. Please open it with the 32-bit version of Microsoft Access."
I'm learning this as I go, and reading that while it may be possible, it may also not be possible depending on the complexity of the database.
It's .accde btw, I messed that up earlier.
@pete-s said in
Are they just opening the MS Access database or are they actually running an MS Access application or some other application that is using the MS Access database?
They are opening the database directly, well the frontend of it I think. There's no software involved other than and Access database (.accdb) (.accde) I know for sure.
@irj said in
Convert the access database to SQL and put it on Azure SQL on a tiny instance that's only spun up when uou need it
I had a feeling SQL would be a suggested solution and have been watching videos on it. Does this sort of thing happen pretty seamlessly or does it take a big amount of setting up the tables, etc. before the import?
Okay, let me preface this with "I'm not a database guy". Moving on.
We have two users who require 32bit Office suite to open a very old Access database. They are the only two in the entire organization who need 32 bit, and it's getting really old having to do everything for the OTHER database that EVERYONE uses (to include them) in both 64 and 32 so they can still use both.
My first and only idea so far is to swap them over to x64 Office suite, and then using VirtualBox or similar, make them a VM with x86 Office suite so they could run the old database.
This isn't a great solution, imo. These folks are not tech savvy and I feel like throwing a VM at them would make their heads explode.
I'm looking at Microsoft Access alternatives, but my priority would be to ensure the the database would function the same, and have the ability to be replicated or be imported from the old one with minimal issues. I don't know a lot about database stuff, and this just doesn't seem like a thing to me, or at least something where the solution would require me to rebuild everything from the ground up to match the old one, which at this point, I'm unable to do in any timely manner, but I'm open to suggestions and actively trying to learn about it.
Taking a minute to myself after someone high up decided to reorganize who's in what department, their respective department names, and the physical location of each without giving my department a heads up. We've got 30+ people swapping offices, trading department supervisors, and calling me because they don't have file permissions for their new department, they don't know why their keyboard doesn't work (they didn't turn on their computer), and "I moved offices, can you set me up?".
It's been a rough day to be the only person in my department.
@scottalanmiller I'm reading a lot right now. It seems that it's been done, but it gets hairy with drivers.
I'm also reading that Linux works pretty well on older Mac's.
I'm going to try swapping out the failed HDD for a new one on this old iMac and see if I can't get Win10 on it. This is really just for fun.
Before I begin, as this is something I've never done, do you all have any tip/tricks or best approaches you want to throw out there?
I'm thinking the best approach my first attempt would be to image a HDD with Win10 using a surrogate machine, and then remove it/install it in the iMac, but I'm open to experience on the matter.
Unboxing and setting up this many Chromebooks.
A recent "project" that was sprung on me but we didn't end up going with involved a cable run of about 200ft from a GPU to a TV.
Now I know there are Fiber optic HDMI cables that appear to be one-way and can reach distances of 200ft, but with that aside, what would be the recommended way to hit 200ft+? I was thinking maybe HDMI from the TV to a HDMI/cat 6 converter, cat 6 to run the distance, and then into another HDMI/cat 6 converter for HDMI into the GPU. Does that sound like it would work?
I know someone has done this, what's the best approach?
@hobbit666 said in Build or Buy?:
What would suggest today for a gaming PC?
Budget is £700 for just the box. Also any recommendations on specs, daughter wants to play Minecraft, Sub Nautica, Fortnite.
(But i want to be able to play Counter Strike, Modern Warefare (not fussed running at Ultra detail settings))
I had pre-ordered a gaming pc on some boutique builder site, but the wait time is intense. Roughly two months-ish. While waiting on that build, I saw a rig on Newegg for $2,669 about a week ago with RTX 3080 and i7 10700KF, some budget case, and a decent Z490-P mobo with included EVGA keyboard and mouse, so I bought that right away and got it within 24 hours.
Needless to say I can run anything I've tried to play on Ultra. Overall this was the way to go considering the current market.
@jt1001001 said in Network Printer keeps re-adding itself:
@mr-jones Xerox has a feature called WSD that allows for Windows to discover printers, sometimes automatically. Try disabling WSD on the xerox to see if that alleviates the issue (we disable it on all ours)
I had to double check, but it's turned off on all.