|
|
| Subject |
|
| Default |
|
|
|
![]() |
 |
Developer and sales person required |
|
| Nigel |
reply
|
02 Feb 2010
18:01 |
|
|
|
|
|
|
|
![]() |
|
We've moved |
|
| Nigel |
reply
|
01 Feb 2010
20:09 |
|
|
|
|
|
|
|
![]() |
 |
Time to upgrade to MS SQL? |
|
| Nigel |
reply
|
13 Aug 2004
09:25 |
|
Microsoft Access databases do work over a network but because it isn't true client/architecture you will find that with several users that speed will become a real issue. Microsoft Access also locks pages of records which means that it locks 20 at a time when you're only editing one of them. This can mean that other users can't update the record that accessing.
If you are experiencing either of the above problems then the solution might be more simple than you think. Microsoft have attempted to smooth the path for converting Access databases to SQL Server and although the job is far from perfect it is still the natural choice for progression.
The only other major factor in upgrading is cost. Many companies don't realise that they actually own a copy of SQL Server and for those who don't the cost for the SQL Server enterprise edition is suprisingly good value. Furthermore; the MSDE (Microsoft's SQL Server Desktop Edition) is free and will be more than sufficient for many small companies.
Once you have made the move to SQL Server you will be amazed at how much faster your applications start working and you'll get no more record locks (providing that your applications and database are structured properly). |
|
|
|
|
[Add a new thread] |