Resources for Learning elements of MS SQL server

[ThomasSoerensen]

Access? I mean how much are we talking about here and who are the end users? Just yourself or a department or business. Would they mind getting Access snapshot reports or do they want web front end?

I will be the only user - but I cannot use Access anymore as I run into the limit of 2gb db size.

I will be the only user. The db will generate a report I present.

[Grinder]

No, don't use Access for the db, use the SQL Server db, but connect from Access using ODBC & bring down the minimal set of results to Access.

[lilelvis2000]

No, don't use Access for the db, use the SQL Server db, but connect from Access using ODBC & bring down the minimal set of results to Access.

WHS.. I do this for my client. works brill. You'll need to use passthroughs to get performance if you've a lot of data.