SQL Server Express

[Guest]

I need to get around the 2Gb limitation in Access, but don't really want to
completely redo all by VBA code (or do a bunch of splitting). Does anyone
know if I can use the new 2005 version of SQL Express as a database and run
Access VBA and queries against the database (from within Access). I could
just link to the database, but would that eliminate the size limitation?

Thanks.

 

[Guest]

According to Microsoft here:
http://lab.msdn.microsoft.com/express/sql/Features/default.aspx
it will have a 4 gig limitation.
and yes you can link your SQL Server tables in your
Access database to continue using all of your old VBA code.

Limited to 4 GB database size

-- Take Care & God Bless ~ SPARKER ~