Access 2000 to Sql2000 : file size change?

I have an Access 2000 database with 640,000 records.
(growing weekly) File size is hovering around 245MB.
I plan to import/convert this database into a new database
on our SQL2000 server. (As soon as I finished that
chapter of the book!)
Implementation planning question: Will the database size
change significantly either way once it's imported in SQL?
TIA,
TeresaIt will probably me less than with Access.
When you import the access stuff, take a minute to check the column-type
definitions and optimize it for your needs.
You might also want to check indexing (wizard) when running on SQL2000 with
your applications, so you can provide propre and fast usage.
jobi
"teresa" <teresaj@.vvh.org> wrote in message
news:06c301c35550$497ded40$3501280a@.phx.gbl...
> I have an Access 2000 database with 640,000 records.
> (growing weekly) File size is hovering around 245MB.
> I plan to import/convert this database into a new database
> on our SQL2000 server. (As soon as I finished that
> chapter of the book!)
> Implementation planning question: Will the database size
> change significantly either way once it's imported in SQL?
> TIA,
> Teresa
>sql

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
Define "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas

"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare
|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding €40million. Your idea might be different.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare

Access

Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mareDefine "best." Yes, it is a tool, but there are many. It is easy to
develop and query attached SQL Server files.
Sincerely,
Anthony Thomas
"mare" <mare@.discussions.microsoft.com> wrote in message
news:62DC38BD-53BE-4B31-BF5D-92B8B29AFF66@.microsoft.com...
Is Access the best tool to use with SQL 2000 Server for a medium sized
company. This is the direction they plan to go with & it doesn't seem right
to me.
mare|||mare,
To do what? Reporting, querying, full blown app? I personally would say
no. Depends on the skills you have in-house, budget, requirements, etc.
Many variables...
Define medium-sized company for us too. The UK govenment consider a
small or medium sized enterprise (SME) to be fewer than 250 employees,
and annual turnover not exceeding â?¬40million. Your idea might be different.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
mare wrote:
> Is Access the best tool to use with SQL 2000 Server for a medium sized
> company. This is the direction they plan to go with & it doesn't seem right
> to me.
>
> mare