V
VS Sreenivas
I have recently moved from Access to MSDE.
I have found the following problems with MSDE:-
1. The same data in MSDE occupies almost double the
space!. Tried shrinking the database with Enterprise
manager. Event then, for a table with about 200,000
records, the space occupied by Access project database is
double that of Access.
2. I find that working on records in Access project is
painfully slow compared to an Access database with the
same tables and quantum of data.
3. I get a 'time out' error when trying to change data
for large tables.
Are these to be accepted when moving from the comfort
of 'Acess' to MSDE?
Pl help.
I have found the following problems with MSDE:-
1. The same data in MSDE occupies almost double the
space!. Tried shrinking the database with Enterprise
manager. Event then, for a table with about 200,000
records, the space occupied by Access project database is
double that of Access.
2. I find that working on records in Access project is
painfully slow compared to an Access database with the
same tables and quantum of data.
3. I get a 'time out' error when trying to change data
for large tables.
Are these to be accepted when moving from the comfort
of 'Acess' to MSDE?
Pl help.