August, 2014
Convert Access Database to MySQL
http://www.bullzip.com/products/a2m/info.php Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL. Wizard interface. Transfer data directly from one server to another. Create a dump file. Select tables to transfer. Select fields to transfer. Transfer password protected databases. Supports both shared security and user-level security. Optional transfer of indexes. Optional transfer […]
Connect Access database to Remote MySQL database
To connect to a local database (using MyODBC Driver)oConn.Open “Driver={mySQL};” & _ “Server=MyServerName;” & _ “Option=16834;” & _ “Database=mydb”To connect to a remote databaseoConn.Open “Driver={mySQL};” & _ “Server=db1.database.com;” & _ “Port=3306;” & _ “Option=131072;” & _ “Stmt=;” & _ “Database=mydb;” & _ “Uid=myUsername;” & _ “Pwd=myPassword”To connect to a local database (using MySQL ODBC 3.51 Driver)oConn.Open “DRIVER={MySQL ODBC 3.51 Driver};” & _ “Server=myServerName;” & _ “Port=3306;” & […]
VS1 Plesk mailbox. Client unable to delete on webmail / increase size of mailbox size
For VS1 customers, if mailbox is full and unable to delete emails via webmail with error “You have reached your mail quota” upon email deletion, follow the steps: Login to Plesk VS1 and choose customer. Click on domain. Under General tab, click on Customize. Increase the mailbox size (+10MB should be enough) Advise client to […]
SMX Provisioning email (Hosted Email)
Copy of email sent Hi David,This email is to confirm that the provisioning for your requested SMX services has been completed.The Next Steps – DNS Changes – Hosted ServiceThe next move is to update the DNS MX records so all inbound email is relayed to our servers. The recommended MX records are:10 mx1.nz.smxemail.com20 mx2.nz.smxemail.com(Ensure there are no other MX […]
Corrupt Microsoft Access MDBs FAQ
(Updated 2010/10/23) Make a backup! Before doing anything else. Preferably on another computer or CDR as a there is a slight possibility the hard drive in question is failing. A successful repair isn’t sufficient to ensure your data is clean. I’ve personally seen a 120 Mb backend MDB repair just fine but both compacting and importing […]
MS Graph Fix for Access Database / Report Chart
http://ourworld.compuserve.com/homep…p.htm#GRAPHGEN The columns in query need to be the same so add a blank column. Also Try: Inserting chart into NEW report. Removing the linked fields master/child worked for IPCA chart (put criteria in the query)Some of the most common questions related to Access reports involve problems with Microsoft Graph or formatting Graph presentations. Here’s […]
Business social media marketing / facebook
Business social media marketing http://growsocial.co.nz/socialmediamarketing/small-business-packages/ Referred by Jane Richardson Owner An Extra Pair of Hands Ltd www.anextrapairofhands.co.nz Jane met Kim at Venus
How to create/delete a startup program when user logon in Windows 7
1. Right click on the exe file of the program you want to run at startup, or file to open at startup, and click on Create Shortcut.NOTE: This is the shortcut that you will add to the Startup folder in either Option One or Option Two below. Skip this step if you are only removing a shortcut from the Startup folder. 2. Open […]
Orcon disabled PHP on Windows servers
Orcon has permanently disabled PHP on all windows servers which has resulted in NZRF being unavailable. Orcon windows servers may be disbanded permanently. We can not use Orcon windows hosting any more for php. There was no warning about this at all.
Re enrollment of IPCA phones to Vodafone VSDM
The steps are: Remove the MDM profile from the Settings>General>Profiles section. (this removes all old profiles) Remove the Vodafone Device Management Agent and insure the Airwatch MDM Agent is installed (if not uninstalled) Open Airwatch MDM Agent Click on proceed without email address Enter Organisation Group = IPCA_Prod Enter MDM Server = mdm-ds.vodafone.co.nz Enter UserName (i.e. phillips) Enter Enrollment […]