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 - 2002-08-16 : 08:50:33
|
| Justin writes "Our company currently distributes a database which uses Access 2000 runtime as the front-end/back-end. This database is used by single users on desktop machines to retrieve scientific data. The database is also noticeably slow (one table contains 8 million records).We are considering upgrading to SQL Server Desktop Engine (MSDE) and use the current Access front-end code. Unfortunately MSDE has a 2GB limit, which we are nearing. Is it possible to link multiple databases together in MSDE? We are actually doing this in Access 2000 but it is quite slow." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-16 : 09:28:17
|
| I'll bet that if you compact the Access database(s) they'll be less than 2 GB, probably substantially less. And if you are running a fully-compacted Access database that's 2 GB in size, that's some accomplishment!If you really have 2 GB of data, or even 1 GB, you should bite the bullet and use SQL Server. It's only a matter of time before it grows to something that's unmanageable under MSDE. |
 |
|
|
|
|
|
Getting around 2GB limit with SQL Server Desktop Engine