Hello,

I have a cloud server where I am hosting a website. It is a Windows Server 2012 R2. Recently I noticed a message in my account control panel saying something like this:

"CRITICAL NETWORK - 384 kbit/s received       12.11 MBit/s transfered"

This is the first time I received a message like this. The server has been operating since 2015.
I am not a network administrator so I do not really know how to proceed. So, I will very much appreciate any support/help you can provide to find out what is going on.

I had watched the Network Activity in Task Manager and I am attaching a screenshot just as a reference. Maybe I need to go over log files but I a not sure which ones are the correct to review and how to proceed.

For example, I watched the System log and I see error entries like this:

"A fatal alert was generated and sent to the remote endpoint. This may result in termination of the connection. The TLS protocol defined fatal error code is 10. The Windows SChannel error state is 1203."

I found the error below in the Administrative Events log:

"The RD Session Host server received large number of incomplete connections.  The system may be under attack."

Something I should say is that I use Remote Desktop to connect to my cloud server.


Respectfully,
Jorge Maldonado

When users visit a website hosted on a virtual server at a client site, they are getting a Error and have to refresh the page.
If I select the URL in the toolbar, and hit enter, the page refreshes and it comes up. but then I click on a menu option and it will then time out with the same error unless I hit the uRL and press enter to refresh the page. I have to do this every time I move from one link to another.

The server the site is on is Server 2016.
IIS is where the site is hosted.

I don't see any security updates with Microsoft that could be causing this block. The support entity told me to uninstall a specific security patch that isn't installed. So not sure where to go.

Hello experts - We recently had a major problem with our internet provider (Broadview) and have been down for more than 30 days.  I'm looking to switch providers but don't know where to start.  Broadview's service had been purchased through a VAR which I'd also like to get away from.  Where can I go to find out who can provide dedicated business internet service with 10 public IPs for us in my area?  I've already tried FIOS and they are not available at two of the three sites I need to connect.  I've got Comcast/Optimum as my failover already setup and need to find a primary, preferably with 100mb service.

I am not an MS Access person.  I have a 3800 row spreadsheet that I want to get into MS SQL, however, I want to see if the vision is correct before I go to the trouble.  I have the spreadsheet imported into Access.  No problem.  I created an entry form to add new ones.  I believe.  I would like the form to do a couple of things and am not sure if it's possible.  What I'd like to have happen:
User opens database and gets form.
User enters an account number.  If the number is already in the table, the form is auto-populated with the information from the table allowing the user to change and update any of the fields, as needed.  If the account number is not in the table, the user completes the form and the record is added to the table based on a field that is also populated on the form.  An example of this is account number 1234 is not present in the table.  The form remains blank.  All information is entered into the form.  One of the fields is a store location.  Instead of adding the record to the table at the bottom, it append the record to its specific location.  So if we have locations 1-12 and account 1234 is serviced out of store 5, the record does not got to the bottom of 12, but is inserted somewhere with the 5's.

Is this even possible? And if I get it to work in Access, can I import and have the same functionality in MSSql?

Hello the experts !

I got this little macro I use on horizontal plannings to go to today cell

Sub GoToToday()
'On déverrouille la feuille, on se positionne
    ActiveSheet.Unprotect
    Cells.Select
'Puis on va chercher la cellule qui contient la date du jour et on la sélectionne
    For Each Cell In ActiveSheet.Range("Y3:PG3")
    If Cell.Value = [Today()] Then
    Cell.Select
    End If
Next
End Sub


Works perfectly fine

But I need something more from this macro today, I would like to check if the "today" cell is part of a grouped range and if it is, ungroup this range (without clearing the outline, just expand and leave it that way)

Your help is very welcome !

Kind regards,

Mélanie

Hi There,
We are testing our new website on Test environment , Couple pages on it uses angular 8  and the images on it is not displaying  when we go to our test website from within our organization, when we check from outside our network it works fine.

We do use OpenDNS to block certain category of web, so if we change our dns to use google public dns 8.8.8.8 the test website displays the images correctly. We did try to disable OpenDNS still the web site doesn't display the images. So something internal when we use our DNS is blocking it.
Till we figure this completely,  is there a way inside our network where we can adjust the host file  or something so only for this particular website which we know is safe we can default it to use the dns server 8.8.8.8 and all other request go through our DNS server which basically gets forwarded to OpenDns.

so for example anybody inside our networks look for www.example.com  8.8.8.8 should be the dns server that should resolve it, any other website should go through our DNS.
I will appreciate anybody has any idea if we could do that and if so how..
Thanks

I just setup a 2019 standard server and created the first VM guest.  When I go to connect to that guest in hyper-v manager, the display window is larger than the screen.  Both the host and guest instance are set for 1024x768.  I do not have the option to grab any of the borders of the window to drag and make the window smaller.  This should be straight forward.

Hi

I have been asked to provide functionality for an Access database that allows users to change the images and label text on a form. What is the best way to go about this?

Thanks

I want to send the data from Ms Access VBA/Json to a general website which does not require authorisation, but the data does not go there below is my "POST" method:

Option Compare Database
Option Explicit
Private Sub CmdSales_Click()
  
'  Const SQL_SELECT As String = "SELECT * FROM Qry1;"
  Dim http As Object
  Dim coll As VBA.Collection
  Dim dict As Scripting.Dictionary
  Dim db As DAO.Database
  Dim rs As DAO.Recordset
  Dim fld As DAO.Field
  Dim qdf As DAO.QueryDef
  Dim prm As DAO.Parameter
  Set http = CreateObject("MSXML2.XMLHTTP")
  http.Open "POST", "http://jsonplaceholder.typicode.com/invoices,False"
  http.setRequestHeader "Content-Type", "application/Json"
  http.send ConvertToJson(coll, Whitespace:=3)
  Set db = CurrentDb
  Set qdf = db.QueryDefs("Qry1")
For Each prm In qdf.Parameters
    prm = Eval(prm.Name)
Next prm
Set rs = qdf.OpenRecordset()

Set qdf = Nothing
  Set coll = New VBA.Collection
'  Set db = CurrentDb
'  Set rs = db.OpenRecordset(SQL_SELECT, dbOpenSnapshot)
  If Not rs.BOF And Not rs.EOF Then
    Do While Not rs.EOF
      Set dict = New Scripting.Dictionary
      For Each fld In rs.fields
        dict.Add fld.Name, rs.fields(fld.Name).Value
      Next fld

      coll.Add dict
      rs.MoveNext
    Loop
  End If

  rs.Close
  Set fld = Nothing
  Set rs = Nothing
  Set db = Nothing
  Set dict = Nothing
  MsgBox "Post Success"
  Set coll = Nothing
End Sub

Select all Open in new window

Just also in case of the username/password required where do I put it in the code above?


Regards

Chris

I need to create several hundred email addresses. I would prefer to create Google accounts and use the Gmail addresses. These need to be free accounts and not G Suite for Business accounts.

These are not for spamming or scamming. Rather, we are a non-profit organization configuring several hundred Kindle devices for students in remote areas around the world. To do this, we need to create hundreds of Amazon accounts using hundreds of unique email addresses. While the creation of the Amazon accounts will be laborious, I think I can do it. We will configure one device per Amazon account, and each account will purchase 60 books. I would like to use Gmail addresses/Google accounts for email, as I am not yet sure if we will be using Kindle, Kindle Fire, or the Kindle app on an Android tablet. If we go with the app, then we will need to use Google Play, which will require a Google Account.

Once each device is loaded and configured, the email/Gmail/Google account as well as the Amazon account (and loaded device) will be handed over to the end user who will take ownership of the Amazon and Google account. We will be providing these as gifts; we are not reselling accounts and devices.

What is the best way to create many Google accounts without raising red flags? In the end, we need around 250 accounts. We don't need to create them all at once.