Data truncated error message - why?
I'm using Microsoft Visual C++ 6 professional. I'm trying to write a database program using the MFC AppWizard to access a Microsoft Access (.mdb) database using ODBC. Some databases allow me to access their tables with no problem (that is when I'm executing the program via Visual C++), and, some other databases, when scanning through the record sets, give me a popup message saying 'Data truncated.'
Could it be that when the database file is too big I'm getting the error message as a bug and should use something like MS SQL Server (i.e. something more prone to handling larger database files)? Or is their a potential conflict with the 'newer' database files (Microsoft Access .mdb files) being run under an older Visual C++?
Thanks for any help.