It works well with Express 2005 but I do have the latest .net framework on that server.

It works well with Express 2005 but I do have the latest .net framework on that server.

i've been using SQL Express for production for over three years without a problem, some database tables with 10+million rows. this serves a light volume user community of about 200...

I schedule contig to run weekly

If you're still using Upsizing Wizard, then you should have a look at SQL Server Migration Assistant for Access, free download from Microsoft.

Regards,

Jim

I run contig.exe online, and have had no issues

Regards,

Jim

I run contig.exe on specific databases to keep the files in one piece.

Regards,

Jim

You cant use the designer in Access 2003 with SQL Server 2005. Use SSMS instead, or convert to Access 2008.

I have over a hundred users of Access 2003 apps on two continents; the apps run quickly and there is no reason to use anything else for these apps. I...

I use Express 2005 as a production server, along with a freeware scheduler called SQLScheduler. This server holds several databases the largest of which is around 3gigs and has one...

I think that is correct. Actually you could build a sql view in access 2003 by using a pass through query not with the designer.

You'll have to design the view in SQL Server. Access 2003 can't build object in SQL Server 2005, just 2000

SSIS is missed but there is an open source scheduler that works very well called SQLScheduler at lazycoding.com

There is a program named DTSWizard.exe that I think was added with SP1 that should do the trick for you.

There is also Microsoft SQL Server Migration Assistant for Access...

My experience is that Express can handle a 2.7 gb database that has a 9 million row table and several other dbs and 75 users very well.

The db is...