If you are running McAfee antivirus you may have a problem resulting from a bug in a recent update from McAfee which cripples your XP machine.
We noticed this in a machine that lost all network function, could not copy or paste and had other quirky behaviour.
After scanning it with several antivirus programs we found that the 'svchost' was being deleted. We were able to copy this file onto the relevant folder by putting the disk in another computer.
We could then open the system successfully in safe mode and remove the bad McAfee.
After that we installed a copy of Panda Antivirus which has proved successful for us.
You can find more information by clicking on these two links
http://www.longislandpress.com/2010/04/21/w32wecorl-a-wecorl-a-dcom-server-process-launcher-terminated-what-it-means/
http://vista.blorge.com/2010/04/26/mcafee-to-compensate-home-users-over-xp-update-bug/
If you are having problems with this issue we can help out.
Tuesday 27 April 2010
Tuesday 13 April 2010
Advice to those tempted to try Office 2010 beta - DON'T
As you would expect it is right that people like ourselves should keep up with what is new and up and coming.
We therefore felt that we should try out the Office 2010 beta products.
First if you are running a 64 bit machine and have 32 bit versions of Office installed you cannot install the Office 2010 64 bit version.
We installed the 32 bit product. We then tried to read out emails.
Our copy of Outlook 2003 would not run because of a corrupted file.
The beta version of Outlook 2010 initially would not allow us to read any of our existing emails.
Eventually we could read the existing emails but we could not send and receive mail - getting a message that this was not implemented.
We googled for this and found a lot in blogs discussing this problem dating back to November 2009 so why is it that Microsoft have not patched this and released it. One site did have a work round - install the beta, uninstall the beta, re-install the beta and then it might work.
Then it wanted something called Outlook Social Connector to enable interconnection between Hotmail, Facebook, Twitter and a whole host of products that I do not use nor want to use.
What I want is a good solid email client program that collects and send my email - I don't need all the rest, and if I ever do want a Facebook client I will find one.
At this point I informed Microsoft through their feedback mechanism exactly what I thought of this product and that it would be removed from my system.
I then ran a system restore to a point further back than the install. Luckily I have been able to get all my historic emails but all my contacts have been obliterated
So if you are thinking you should try the new Office 2010 beta product our advice is simple. DON'T.
I do not feel we can say it any better than that.
It is time for Microsoft to get back to providing good solid products not a load of fancy cradle to grave software that doesn't do what it is meant to do.
We therefore felt that we should try out the Office 2010 beta products.
First if you are running a 64 bit machine and have 32 bit versions of Office installed you cannot install the Office 2010 64 bit version.
We installed the 32 bit product. We then tried to read out emails.
Our copy of Outlook 2003 would not run because of a corrupted file.
The beta version of Outlook 2010 initially would not allow us to read any of our existing emails.
Eventually we could read the existing emails but we could not send and receive mail - getting a message that this was not implemented.
We googled for this and found a lot in blogs discussing this problem dating back to November 2009 so why is it that Microsoft have not patched this and released it. One site did have a work round - install the beta, uninstall the beta, re-install the beta and then it might work.
Then it wanted something called Outlook Social Connector to enable interconnection between Hotmail, Facebook, Twitter and a whole host of products that I do not use nor want to use.
What I want is a good solid email client program that collects and send my email - I don't need all the rest, and if I ever do want a Facebook client I will find one.
At this point I informed Microsoft through their feedback mechanism exactly what I thought of this product and that it would be removed from my system.
I then ran a system restore to a point further back than the install. Luckily I have been able to get all my historic emails but all my contacts have been obliterated
So if you are thinking you should try the new Office 2010 beta product our advice is simple. DON'T.
I do not feel we can say it any better than that.
It is time for Microsoft to get back to providing good solid products not a load of fancy cradle to grave software that doesn't do what it is meant to do.
Friday 2 April 2010
Creating reports based on user input criteria in OpenOffice BASE
I was searching the Open Office Community forum to solve a problem but did not find a direct answer. However I think I have worked out a method so I thought I would share it.
My development rig is using standard OO DB drivers. My production rig is using MySQL on our domain server to allow shared access.
I am using 3.1.0 on the development rig Windows 7 based. I am hoping my production rig will work from Windows and Linux platforms.
It is only a small database taking over from a spreadsheet which is getting too unwieldy to work.
I have 3 tables:-
Clients: clientno, name, contact, addr1, addr2, postcode
Record types: recordno, typename
Details: recordno, recordid, clientid, username, password, url, extra
Details.clientid = Clients.clientno
Details.recordid = Records types.recordno
I want to be able to generate a report which extracts from the DB all records pertaining to a particular client and allow the user to enter the client name after selecting the report to run. [Ideally I would like to do this selection from a form but I will live with what I have got at the moment]
I have in the past written db programs using basic ISAM files. I have recently been writing web apps using MySQL DBs so I had a good idea of how I wanted my solution to look. I just wasn't getting how to do it in OO and I have never found the patience to work through MS Access.
My solution.
I created a view with all the fields from the Detail record with links to the relevant tables elsewhere and saved this View as 'Details View'.
Next I went to queries and set up a new query. When I got to the Search Conditions I selected View.clientname in the fields box put in " :Enter_Client_Name " in the values box as suggested elsewhere in this forum but without the double quotes [and this point is important].
I then completed the query. When I ran it it gave me an empty list. I went back in to 'edit by SQL' and noted that the SQL had placed my :Enter_Client_Name in single quotes and thus it was not being found. I took off the single quotes [please note the input field turned green at this point]. Running this query allowed me to input the client name successfully.
Then I set up a report using this new query as the basis of the report. Running the report now allows the user to enter the name of a client on which they want to generate a report.
I am not going to say that I may not need refinements on this but I do believe that this gives other newcomers to OO DB a chance to make progress. Given a number of the posts on the forum I feel this is at the base of a lot of the queries.
The original post can be found on the OpenOffice.org Community Forum at this web address http://user.services.openoffice.org/en/forum/
Many thanks to all contributers to that forum.
My development rig is using standard OO DB drivers. My production rig is using MySQL on our domain server to allow shared access.
I am using 3.1.0 on the development rig Windows 7 based. I am hoping my production rig will work from Windows and Linux platforms.
It is only a small database taking over from a spreadsheet which is getting too unwieldy to work.
I have 3 tables:-
Clients: clientno, name, contact, addr1, addr2, postcode
Record types: recordno, typename
Details: recordno, recordid, clientid, username, password, url, extra
Details.clientid = Clients.clientno
Details.recordid = Records types.recordno
I want to be able to generate a report which extracts from the DB all records pertaining to a particular client and allow the user to enter the client name after selecting the report to run. [Ideally I would like to do this selection from a form but I will live with what I have got at the moment]
I have in the past written db programs using basic ISAM files. I have recently been writing web apps using MySQL DBs so I had a good idea of how I wanted my solution to look. I just wasn't getting how to do it in OO and I have never found the patience to work through MS Access.
My solution.
I created a view with all the fields from the Detail record with links to the relevant tables elsewhere and saved this View as 'Details View'.
Next I went to queries and set up a new query. When I got to the Search Conditions I selected View.clientname in the fields box put in " :Enter_Client_Name " in the values box as suggested elsewhere in this forum but without the double quotes [and this point is important].
I then completed the query. When I ran it it gave me an empty list. I went back in to 'edit by SQL' and noted that the SQL had placed my :Enter_Client_Name in single quotes and thus it was not being found. I took off the single quotes [please note the input field turned green at this point]. Running this query allowed me to input the client name successfully.
Then I set up a report using this new query as the basis of the report. Running the report now allows the user to enter the name of a client on which they want to generate a report.
I am not going to say that I may not need refinements on this but I do believe that this gives other newcomers to OO DB a chance to make progress. Given a number of the posts on the forum I feel this is at the base of a lot of the queries.
The original post can be found on the OpenOffice.org Community Forum at this web address http://user.services.openoffice.org/en/forum/
Many thanks to all contributers to that forum.
Subscribe to:
Posts (Atom)