OK so in 2010 we shouldn’t still be dealing with Access 97 databases but in the real world some people still have them! So a client tells me their Access 97 database form is showing them the wrong data for the date range they enter. The form is opened from a command button on another [...]
If you have to install Microsoft SQL Server 2000 on Windows 7 you’ll find that Windows Sync Center automatically starts at Windows startup. Opening Sync Center will show that Microsoft SQL Server 2000 has been automatically added and cannot be deleted. To remove this sync partnership you need to edit the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SyncMgr\Handlers Find [...]
Running PHP on a Windows 2003 Server and connecting to Microsoft SQL Server 2000 Service Pack 4 we found that sometimes the PHP script could connect to the SQL Server but most of the time we’d get ‘mssql_connect() unable to connect to server’. After Googling the problem I found a lot of references to needing [...]
I recently had to backup and restore a MySQL database so I dumped the whole database into a SQL file but when I came to restore I found that in one of the biggest tables a lot of the data was missing. Looking at the warnings when I ran the restore query I found I [...]
One issue I’ve found using Microsoft Access as a front end to MySQL is that when running an update query I often got an error saying the record was not updated due to a lock violation. It turns out if the data Access is updating is the same as the existing values then it gives [...]