Access, Access 2000, Access 2003, Access 2003 forms, Access 2007, Access 2007 forms, Access 2007 functions, Access control, Access Database, Access forms, Access Points, Access query, Access Tables, BLOB, Clustering, CSV, Database administration, Database connectivity, Database design, Database issues, Database management, Database Management Systems, Database migration, DB2, DB2 administration, DB2 Universal Database, DB2/400, DBA, DBMS, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, INSERT statement, JDBC, JOIN statement, Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access forms, Microsoft Access subforms, MySQL, MySQL Database, ODBC, Query optimization, SQL queries, Sybase, Triggers VIEW ALL TAGS
We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?
I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 126.96.36.199 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table I get ONLY ONE ROW without any...