A small question here...
We have here a number of MS Access 2003 applications we want to upsize to MS SQL server.
What I would like to know is it possible to use MS SQL 2008 Server for this (or would we be better off with another version as MS SQL 2005 for instance)?
Is ODBC our only option to connect to the MS SQL Server? Currently we have one or two ODBC connections to an Oracle database, but they perform badly (which is in this case not a real problem because they are only used to pull information from Oracle during a nightly automated run).
Thanks in advance for all usefull information.
Rob.
We have here a number of MS Access 2003 applications we want to upsize to MS SQL server.
What I would like to know is it possible to use MS SQL 2008 Server for this (or would we be better off with another version as MS SQL 2005 for instance)?
Is ODBC our only option to connect to the MS SQL Server? Currently we have one or two ODBC connections to an Oracle database, but they perform badly (which is in this case not a real problem because they are only used to pull information from Oracle during a nightly automated run).
Thanks in advance for all usefull information.
Rob.
