Search results for query: *

Just an update, since I denied the IP on the firewall, there are no more sessions coming through so I assume was spam, etc.

Thought I would share my findings as might help others with a similar problem. To get the session details, you need to connect by console (i.e. telnet server IP) and then the session commands are: get session info ----> details of the number of sessions get session ----> details of...

I have high traffic hitting my SMTP server from 216.139.246.155. Hits every couple of seconds which are keeping sessions open on the firewall. nslookup shows the IP as aus.us.siteprotect.com. Is this just SPAM hitting my server?

Hi I have inherited a small site with a Juniper ns5gt acting as firewall. The internet keeps being dropped and I think the Juniper is the cause. There is a seperate ADSL modem connected to the untrusted port. This has a live link and has been checked by the telecoms provider. If I logon to...

Hi We have a network which was "professionally" installed by our accounts software provider. A recent HP Proliant ML310 G5 server (Quad Core X3370 3.0Ghz, 8 GB of PC2-6400 800MHz), Netgear GS116 1GB switch and SBS 2008. We have only 5 users and the usage is low. The main app being used is...

Hi I am using an accounts package called "Sage Line 50" with their own bespoke ODBC driver which is installed with the package. I have interrogated the DSN settings which are very simple: DRIVER = {Sage Line 50 v15} DIR = c:\sage\accounts\ UID = username PWD = password Like I say I can...

Thanks for the reply. That is exactly what I planned to do, but have failed. I am using a custom ODBC driver with no documentation. I can get it to work by setting up DSN in control panel, and by ADO connection. But if I try the exact same parameters anywhere else, including pass-thru...

Thanks for the reply. I have tried to create DSN-less, that would be my preferred option. But the ODBC driver supplied is not documented anywhere and I cannot get it to connect DSN-less. I posted last week looking for help on that, as I can get it to work through ADO but not DAO. I get a...

Hi I am trying to create a DSN entry in ODBC Manager for several database connections. I have google'd and used various coding, including Microsoft technet support. But I cannot get any to work. I think the problem is I am running Windows 7 64 bit and the ODBC version is different. Any help?

Hi I have an ADO connection which opens an ODBC connection. I can return a recordset and loop through the records. What is the code to import the results into a local MS Access table. I need to connect to 100 seperate ODBC databases and import 10 tables from each, so 1000 tables imported...

I am trying to import data from multiple ODBC sources. They all have a similar structure but are all independent accounting databases for different companies. I can get the import working by setting up a DSN entry, but would have to setup/amend the DSN entries when companies change. But the...

Our website provider has setup a form on our website. When a user enters their details it sends an email to two accounts at our primary domain and to the webhost. The emails addressed our domain do not get delivered, but they do to the webhost. FYI our webhost loves MACs and I don't know if...

pwise Tried it and it sort of works. It highlights the selection in the list, but does not jump the list to that row.

pwise That sounds ace, will give it a go.

Hi TheAceMan Thanks for the reply, but i need multi select, hence listbox.

I am using a multi-select listbox which works fine and passes the selections to some code. The listbox has a long list of data and I need to be able to quickly find an item. How can I use a combo box to search, as it doesn't work with a multi-select list box. If I click on the list I can...

I have created a new form with just this code and the problem does not recur, so must be other code in my form. I will work through it.

Hi I'm not sure my code will help, but here it is. The listbox is bound to the table being updated, which is what I think is causing the problem. In my code the listbox selection is lost when the line 'DoCmd.RunSQL strSQL' is run, and the code afterwards has no effect. If I remove the...

I have a form with a multi-select listbox of id's and names and addresses. I have vba code which loops through the multi-select listbox to make a criteria string of id's. I use the string to create some SQL which updates the names or addresses of all the id's selected. My problem is that the...

Hi ck1999 I like the idea, but my report has a lot of calculations which are shown in a report with 4 nested group headers/footers and the user needs to preview the report to see the results. I don't think I could achieve the same directly in a form - I would have to use a form, with several...