Other than creating a flowchart, Microsoft Visio is also a very good tool for data modeling. The default database driver set on the software though is for Microsoft Access. Here are the steps to change the target database driver to SQL Server or any other available databases: Make sure you have other database driver you want to use installed on your computer first. Go to the Database menu, … [Read more...]
Linked SQL Server Table Shows #Deleted in MS Access
When linking a SQL Server table (SQL Server 2008 R2) via ODBC, I encountered a major error where all cells in the table display #Deleted when opened from Microsoft Access 2010 (14.0.6123.5001). The problem turns out to be that Microsoft Jet Database Engine maps bigint datatype to binary. One way to fix this is to clone the table and change the datatype from bigint to either int or … [Read more...]