Access, SQL Server on a local network
Posted on 2013-12-09
Right now I'm using Access 2010 to serve as a database for a report application I wrote. Every morning, QuickBooks updates the Access 2010 database using QODBC (an ODBC interface).
Because one of our tables is so big (250,000 records), I'm getting random errors such as Out of System Resources and sometimes the importing just doesn't work.
I'd like to go to SQL Server Express, but I've never set it up on a local network before. Normally I've created SQL databases using a web host.
Can anyone point me in the right direction to get started? I am on a network and other people will need to have access to the database via my program.
Thanks for your help!!!