MS Access
How To Get Around The Cannot Create Index On Given Field Error
In this post I am going to show you a way to get around the “Cannot Create Index On Given Field Error” If you got this error before, I am sure you are frustrated. I am working on upgrading an Access database to SQL Server. There are a lot of tables, but for this post […]
How To Import An Access Database Table Data To SQL server
Do you need to import your Access DB table(s) data to a SQL server to provide for better accessibility from either the location or from the web? Well follow these simple steps. BTW. Get a free download of SMS (SQL Management Studio). That’s what this tutorial is based on. 1. Select the table from the […]
MS Access, MySQL ODBC Write Conflict Error
On one of my projects we have a MS Access database front end hooked up to tables on a MySQL backend. The entry process seemed to be going just fine until my customer encountered the “Write Conflict Error”. This error was frustrating to try to track down and fix. While I was trying to diagnose […]