Search results

Appreciate your input Doc, please don't misconstrue my comments as this is in no way personal at all. I'm grateful of the input, much easier to stay silent & let me fall into a pile of :poop:. There are beautiful brains on this forum with like-minded interests & this is intellectual debate...

Sorry to hear this: As @Gasman suggestion you can access Access update history via File > Account > below I know you said rolling back Windows is not an option but just in case; a previous version Another update causing more problems than they fix :mad:. This is so, so, bad, no wonder they...

Thanks George, oh that's surprising. I would've thought it was tightly coupled with SSMS due to TSQL. I would never have thought it independent. So shouldn't this forum be called 'Microsoft SQL Server'; not SQL Server?

Thanks CJ, I was following your lead :LOL:. Or maybe what is meant by the subforum's definition: As I stated in #13; which I believe was correct; it is relevant to SSMS not 'SQL Server' overall. The SSMA wizard linked will only import to SSMS.

Thanks Ron, I look forward to studying that many thanks.

In Visual Studio I enabled CoPilot; was helpful in correcting my errors in C# as half a decade since I looked at C#, & sometimes I couldn't make out what it was doing.

Thanks CJ, not sure that is entirely correct - the video linked was a migration to SQL Server using SSMA wizard (Microsoft Sql Server Migration Assistant); unique to only Microsoft Sql Server; not SQL Server. To generically state SQL Server here I believe would be incorrect as the Migration...

I'm in same position; I actually have not completed my app fully in Access & moved to SQL Server asap & I'm glad I did because the control-flow/ processes are quite different rendering considerable redesign to work in SQL Server; the more experienced here will hopefully correct me if I'm...

Thanks, I may have muddied the waters with 'a compiled procedure', but this is what I meant to #30; I finally grasped the point you were making. At least what I was trying to write anyways :ROFLMAO:.

Thanks all, yes I keep getting told off about referencing SSMS here; I appreciate the persistence in correcting me. I do want to learn correctly so thank you. Ok, having used various versions of the app I am building from several different companies; as an end-user at large companies, an...

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