| Author |
 Topic  |
|
|
Target_Locked
Starting Member
Vietnam
38 Posts |
 Posted - 11 September 2007 : 02:31:56
|
Hi there,
I now using Access database to store data (text only), but I am afraid that one day in future MS Access is not enough.
How many posts (estimated) can MS Access store?
And then can I transfer existing MS Access data to MS SQL or My SQL? Thanks.
TTT |
Snitz 2000 Ver 3.4.06 |
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 11 September 2007 : 04:01:04
|
Microsoft claims that an Access database has good performance if tables stick to +/- 35000 rows, after that, performance issues will be found, such as long time responces, etc...
it always depend on the machine as well, maybe you should considerate changing to MS SQL (no worries about performance here) or the new SQL Express/Compact versions used in .NET cause all you need is the file and the right queryString, and you will be up and running to 4Gb file and... for free 
SQL Server 2005 Express edition
SQL Server 2005 Compact Edition |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
 |
|
|
Target_Locked
Starting Member
Vietnam
38 Posts |
Posted - 11 September 2007 : 21:26:27
|
Thanks balexandre,
And does anyone know how to transfer data from MS Access to MS SQL or My SQL? Does Snitz have a tool to do this?
Thanks. |
Snitz 2000 Ver 3.4.06 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 11 September 2007 : 21:30:28
|
There are a few tutorials on upgrading from Access to SQL Server floating around.
Here's a short one [link]. A more detailed one was posted. A quick search should turn it up. |
|
|
|
Target_Locked
Starting Member
Vietnam
38 Posts |
Posted - 11 September 2007 : 22:18:02
|
| Thanks AnonJr. :) |
Snitz 2000 Ver 3.4.06 |
|
|
| |
Topic |
|
Topic Locked
