Search results

@Albert D. Kallal your posts always high-calibre, we are lucky to have you on the forum. I missed this completely & still don't see it; sorry @Isaac for bloating your thread with irrelevance. I read the OP as a static website builder, & if that was the case & there was no benefit to using a...

Thanks sonic8, that's very helpful. Found some courses on Azure which I'm looking into now to try to get a grasp: AZ900 MSN - Beginner Azure AZ104 - Azure Administrator

Thanks Ron, ah db level in Azure seems the way to go. Thanks Sonic, I was hoping that would not be the case as I'm just a learner & would've been able to just set permissions covariantly to objects/ schemas... Concentrating on just getting it working atm is what I really hope is possible. I...

I've got plenty to spare, it must be something else. Editing objects was really slow in using an Azure Db for me. Things definitely improved as stated in recent posts thanks to input from forum. However it was too slow to continue developing. I changed to a local instance of SSMS 22 with near...

Thanks Minty, you've got double my RAM. Hmmm I wonder if things will improve or this is as good as it gets for me.

Been working on the premise that if selling an .accde with an Azure db managed through SSMS 22, you can restrict important info/ stored procedures/ tables/ queries... from the customer. I imagine through creating different users/ schema's... creating an admin user account & encrypting data/...

It certainly is much better & the input rec'd has definitely helped (thanks all). Thanks Minty, really appreciated. I'm on minimum package; 5 DTU's; but don't think that's the issue as I'll be doing pretty basic stuff compared to you guys. Only 50 tables & < 20 rows in there; most tables have no...

Old thread & you're probably done now, but in case; I built several of mine handcoded < 10 years ago & yeilds far better SEO results than a templated builder/ type thing. Be careful who you buy the domain from, most of them are con merchants, need to make sure you own the domain. I used...

Thanks Tom, I would've thought that would've got done when reinstalling but giving it a go (EDIT actually not nowadays really, developers rarely delete all traces of their apps/ settings these days) I got warnings with GitHub. Just in case somewhere is aware of anything like this conflicting...

Thanks Tom & for the reasurrance something is wrong. I must fix it now as it's slowing me down too much. Yes I was set to relevant region (UK). I'm experiencing identical issues to this thread. So I changed Connection Protocol to TCP/IP & checked Trust Certificate; still no joy. Ping results...

Update - I dropped & recreated the db; faster opening an object from Object Explorer (1.5 secs). Then added a relationship in the Table Design View; took around 30 secs to load up initial GUI (not Diagram) then after selecting columns 40 secs to add relationship. Then the Diagram took around 90...

Thanks George, I've also tried: Disabling Publisher Certificate Revocation Check in Windows Modified Host File For Certificate Revocation; C:\Windows\System32\drivers\etc\hosts adding 127.0.0.1 crl.microsoft.com to bottom of file No luck on above tried resetting connection settings of SSMS 22...

Thanks Tom, really good of you; interesting, I definitely have a problem which I should solve then.

Thanks Tom, that's helpful. I knew Azure would be slower but surprised with Diagrams atm. I hardly have any data in the db but through Access it's very quick but we'll see how it goes when I get a bit more done. Still a lot to do on the development side.

Hi @sonic8 , I'm usually wrong & know very little, but I thought I saw some posts with people having issues with the ODBC. I thought ODBC strings is how we connect. Well if that's your assumption given your knowledge I'm certainly wrong. I got a prompt on installing the new app about OLE/ ODBC...

Have many experienced this? I'm not talking about through Access or Query performance, I mean the actual application SSMS22 itself is extremely slow. Through Access is quick but I'm working in SSMS most of the time converting the BE for Access. Seems there are quite a few complaints with the...

Beautiful link @RonPaii, thank you, I didn't come across that MSN article which was exactly what I needed. It used to be a popular phrase In English/ Irish communities. I've rarely heard it from my age group, but working on site with the older Irish generation it was commonly used, but less so...

Thanks Doc, I am aware of the enigma with multiplication & division, but thank you for prompting had I not been aware. Don't worry about the possibility of different data-types being used as terms within the expression; I have this covered. I also have it covered where the decimal places...

Congrats @The_Doc_Man, well deserved!

Thanks Doc, Access will be fine with 17 decimal points to display enough accuracy, it is the calculations done in the back-end where i need the accuracy. Are you saying that I need to explicitly round all intermediate calculations regardless of their specified decimal point spec? An...