Hello - let me premise this message with - I am a novice with SQL Server...
I have some questions about upgrading from Access to SQL Server Express:
1) Can I install the SQL Server Express tools on a client PC, but have the database located on a server?
2) For the configuration, can I just indicate the location of the database on the server (from a client PC), or will I have to install components on the server?
3) Can I connect to the SQL Server Express database located on the server through ODBC or some other connectivity software, usnig Access as the front-end?
The current environment is this:
My client has some Access databases (version 2007) that are starting to perform poorly due to increased usage and also users accessing from different physical sites to the network/server at the main site. The databases perform OK at the main site,
but would be nice to see some improvement there as well.
My client does not wish to sp ...
Go to the complete details ...