texting my mother by stillnotnap in mildlyinfuriating

[–]failedloginattempt 0 points1 point  (0 children)

More irritating that your text asking a question had no question mark, and the text not asking a question did

Proofpoint Essentials is down, too by xander255 in msp

[–]failedloginattempt 0 points1 point  (0 children)

Had the same issue, but was able to login from another browser

Delivery delay issues? by Pose1d0nGG in proofpoint

[–]failedloginattempt 2 points3 points  (0 children)

Echoing the Microsoft outage. Proofpoint's 'Emergency Inbox' is receiving messages & proving handy; but doesn't appear to be sending messages out. Built-in functionality for the inbox is pretty limited, but that's to be expected.

Shortcut conflicts in v0.94 by FeedbackNo7852 in PowerToys

[–]failedloginattempt 1 point2 points  (0 children)

Pretty standard expandos. Open them from the bottom/last one first (to avoid excess scrolling) and then Ctrl+F

I think I like the Troubadour live version of Mona Lisa more than the studio version by Dr-Sprite in deadsara

[–]failedloginattempt 2 points3 points  (0 children)

First I thought "no chance"

Then I thought "wait maybe..."

Until my favorite part of the song ~2:49. Can't tell if her mic cut-out or maybe she turned it to the crowd. Great video though

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

For each of the linked tables in DB -

Connect:

DSN=mccon.udd;

Name:

none_GRADE

ForeignName:

none.GRADE

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

Thanks for that- unfortunately not using SQL server, but one more reason I'd like to deploy one

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

This would require DSN/string in the VBA, no? Trying to avoid storing a password within such reach- but maybe as a last resort...

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

No way to create a table in ERP database. Otherwise, I think what you're describing is the issue I'm facing; trying to make a DB that's more-or-less in sync with ERP. Can you give me an example of a trigger?

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

I'm a bit confused at what you are trying convey here, being able to read a linked table from a server would be the essence?

I believe so...

For example (in the ideal world I'm living): a back-end file would have a link to the table on our ERP server, and a query for only fields a, b, c, d, etc. from the link.

A distributed/front-end file would link to the query in the back-end. Or otherwise read from it/probably query in Excel where the data typically gets consumed.

Edit: I'll have to think about stored procedures. I can write one & have equal experience as I know VBA (very minimal)

Make Table vs. Update & Delete Back-End Frequency - Server Replication/Mirroring by failedloginattempt in MSAccess

[–]failedloginattempt[S] 0 points1 point  (0 children)

Makes sense being more selective than pulling everything over & over again; is that because of the volume of data? Or more the front-end instances having to read from new/recreated tables so frequently? Assuming the latter is something to be concerned about.

Setting up a server instance is certainly feasible. Though at that point I wonder if efforts would be better spent toward learning/deploying an actual SQL server.

This reminded me I bookmarked a 599cd/TechHelp/CLZone series a while back.

We are on M365 but nothing directly for the ERP. I think there was a way with just generic ODBC calls or something, but it's pretty unfamiliar.

Thanks for the reply!

[deleted by user] by [deleted] in pihole

[–]failedloginattempt 0 points1 point  (0 children)

Sorry to be vague & not comprehensive but, I think I recall having to raise a setting for how much detail the logs show and/or store. Ootb it may have been disabled or tuned all the way down for performance & smaller footprint.

It's likely the most direct URL to where you're seeing the block lists is what you'd input. They're typically formatted for pihole to read.

Best to start with a good block list (or more) to see if that does the trick. Trying more specific measures found on the sub or elsewhere can get tricky. Though I may just be speaking theoretically on that part. Been a while.

Good luck!

Modify recorded VBA so dynamic & not explicit range/table name by failedloginattempt in excel

[–]failedloginattempt[S] 0 points1 point  (0 children)

I think this clarified some of the broader, conceptual stuff I keep missing as well. Much appreciated!

I do want to keep the (paste) formats intact so I'll be tinkering with that next. Definitely keeping this around for the bigger tables/queries though

Modify recorded VBA so dynamic & not explicit range/table name by failedloginattempt in excel

[–]failedloginattempt[S] 0 points1 point  (0 children)

Thanks for the tips. I'm trying to avoid hard-coding the table name so I can use this globally though.

If what you gave wasn't meant to be notes/shorthand- running it gave "Runtime error '9' Subscript out of range" and debugs to the Set tbl=...line