Search results

Thanks CJ/ GpGeorge, sorry I've used bad terminology here it seems. When I say deploy I mean the client will be using their own SSMS. CJ you've assessed accurately in #22 & I agree a plan is needed, but I've only been in SSMS tinkering circa 1 month, so this is a bit of a stretch for me atm...

Thanks Minty, was not aware that a function could be encrypted. But the problem lies that I am probably going to be deploying SSMS on the client's computer, where the encryption is next to useless. @AHeyne I think I understand what you meant - a compiled .accde (native) formula/ procedure...

Thanks Albert, the tone atm is as if user's are happy updating regularly, to break their software. I don't think they are. My opinion is development has gone backwards recently. You used to be able to rely on software working; now many of my app's which cost several thousand a year regularly...

Thanks CJ, I don't disagree with the security with Access. Some sources suggest that moving the BE to SQL Server would obfuscate business logic. At the moment this seems downright wrong & it would have been safer to stick with Access' JET Engine with a compiled .accde as suggested by @AHeyne, I...

Thanks CJ, agreed - I see a future I do not want to look at here. Seems an impossible task to maintain a consistently changing environment.

Thanks Doc, I don't think I need to worry; my butt just aint that enticing! Cool - test each patch before then email/ permit each patch update & allow the user to install should they desire; got it. Thanks for warning me.

Very important input here - thanks Doc. Was worried about this & vomited 🤮 when reading. I feel this is the biggest problem with modern software development; a constant changing environment which is unproductive, pushing Microsoft's failure onto developers to address. I stop updates on my...

Agreed, I believe this to be the most secure atm. I've read contradictory info on whether Assemblies are quicker or not. As they're in the Common Language Runtime language some say quicker, some say slower. I'm considering C# & seeing if I'd be better with Scalar/ Table-Valued Functions...

Thanks Ron, yes I've seen quite a few articles stating this & linked previously. Granted my input has little value. If you created a 'role'/ whatever that effectively has SA permissions but password protected the different username with effective SA privileges you would remove a general SA hack...

Thanks Doc. I've barely scratched the surface of absolute novice of SSMS/ Access & learnt what a SA was about 3 minutes ago so we can ascertain everyone on the forum is more capable than myself. The only experience I had working with SSMS prior to this was using the app mentioned elsewhere...

Thanks Doc, yep chose Access for RAD, yep took some basic lessons on binary expolitation in Decompilers like IDA, Binary Ninja & another I can't remember now. Was merely trying to ascertain the most secure patterns of implementation for Access. Got some great input so much appreciated.

Thanks CJ, dropping Access & rebuilding at this stage is not an option. I accept the limitations of Access & was aware from the start. & was just asking questions to what is possible to make it as hard as possible so I can choose the best option & input has been extremely helpful (thank you all)...

A user won't but a competitor will (not building a decompiler; but using one). Oh definitely, apologies I'm not a developer, just an enthusiastic donkey🫏 with a goal. Thanks Tom, yes aware - but correct me if wrong but a function's contents cannot be encrypted & hidden from a user. So that...

Thanks sonic8, surely the only interference would be currently executing services/ processes. You could go further and keep a log of all backups & covariantly delete when deleting the application so they have nothing to restore if they try to crack the app. Basic admin (backups.../ restores)...

Thanks Tom, oh so an 'Assembly' is a unit of compiled code ready to be executed & can refer to external .dll's which SSMS can execute. I'm researching them now. Sounding more secure. This addresses security concerns, but I'm failing to see how I could refer to a calc'd column from that without...

Thanks Doc, the connection parameters available in the GUI were all the same. So in the unlikely event that SSMS-22's default properties for the exact same connection differentiated then the connection was the same. Persistent Connection - MS Access is not at play yet. Opening SSMS connected to...

CJ'll know much more than me. I don't think you should be building the query in Access. You want it handled at the BE, then just pull through that query/ view (or equivalent in you BE). There is an issue with Access using a Combo Box that it pulls the record itself from the query to display in...

1 - Silly question here - could one not capture the login event of an SA, delete everything on an SA login? 2 - Disable the SA account 3 - Less effective deterrent - rename the SA account.

Thank you both, happy new year to you both, sorry I did not explain well. Thanks CJ, agreed, my calc's are more complex but this simplifies the topic & the premise of a protecting the formula of a calc'd field in a query (maybe not as I haven't explained it well it all :p). From the user/...

Thanks Doc, that is extremely interesting & I want to learn more of that kind of thing. Going to mark this as Solved; apologies with my inexperience. I think it was more of a connection with Azure with SSMS-22 being slower than SSMS-21 on the same connection. Apologies again.