Re: Access to Other ODBC database
Posted in 1997
Topics: Connectivity: ODBC / JDBC / .NET
Do yourself a big favor. Byte the bullit and remove the spaces and special characters from your column names right now. Microsoft was stupid for allowing them in the first place. Then you can use any number of good database engines(Oracle, Sybase SQL Server, Informix, MS SQL, etc.), and you will be able to read the SQL code as well. Then never EVER admit to anyone that the spaces were there in the first place. ;-) Jim Reineri Rick Duff <rduff@asacomp.com> wrote in article <01bc2994$fa3ef5a0$2588b2c7@rduff>... > I need to know if there is a database program out there > (along the lines of Oracle, SQL Server, Sybase, etc..) > that can handle table and field names with spaces in > them like ACCESS does. I need to migrate an > application to another database that we don't have the > source code to. Our database has 75 users and is > currently 150mb in Access and it's just too much for Access > to handle well. When it corrupts it takes 1 3/4 hours to repair. > Thanks! > rduff@asacomp.com >