Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-19 : 07:46:44
|
| sam writes "hiwe have access database with 20 tables. there r 4 users for this database.and it is too slow. we want to migrate it to access. how long its going to take the whole procees to migrate?? do u think is it a good idea?? any disadvantages?? any suggestions??and how much is it going to cost??(rough idea).thanks" |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-19 : 09:21:39
|
| I would question the move if you are going to install SQL on the same box that the Access app is on. Generally speaking the database isn't too slow, the machine is too slow. Will this be a new server?AjHey, it compiles. |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-19 : 09:57:15
|
| sql server is expensive. if you only have 4 users consider looking at MSDE. It is free. Beware though, there is no gui and you will have to learn the command line. 20 tables and 4 users does not call for a full blown sql implimentation unless you have 100,000's to millions of records. Hardware can be the issue but I am sorry to say a lot of access programmers are not very good and Access is not a client server product unless you properly use Access Data Projects. Access has the tendency to to do dreadful things like pulling whole tables across networks and processing the query on the client... I can go on and on about my hate for that pig they call Jet but I have work to do.====================================================Regards,Sean RoussyThank you, drive through |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-19 : 17:43:12
|
| Might consider MySQL too. AjHey, it compiles. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-19 : 22:21:15
|
 Now go wash your mouth out with soap!Kristen |
|
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2005-08-21 : 01:03:10
|
| HEY! I am just trying to be as helpful as possible! AjHey, it compiles. |
|
|
|
|
|
|
to migrate access to sql server