We have an MS Access database of over 100MB. It is running very slowly and beginning to crash with increasing frequency.
We want to consider going to a SQL Server back end with MS Access front end programming. However, we are afraid of making a large investment until we learn some basic facts.
We know we can re-program our mdb databases to .adp databases.
1) Can we use any SQL Server version? We are running mostly MS Access 2007 but want to move to MS Access 2010. Will a SQL express edition allow .adp programming?
2) Must we have a server to run SQL Server with multiple users? We are currently a pier-to-pier network with about 5 regular users and maybe 5 more occasional users. We had Windows Server 2000 in the distant past but at the time it didn't seem to offer us anything we needed to do that wouldn't work more easily in a pier-to-pier network.
Any input I could get from SQL users would be much appreciated.
We are reluctant to move until we know how things work.
one other thing: we have a mixture of Windows Vista and Windows 7 workstations. I think the Windows 7 are 64 bit versions. I see the SQL Server 2008 comes with 32-bit and 64-bit versions. Does that mean anything to us in a mixed-Windows environment?
Reply With Quote