Is it just me, or once you've used SQL Server, is using Access again (especially for reasonably complex queries) just brutal?
I guess I kinda like having parameters that I can see and use to branch (if necessary) in my stored procedures...
And while I'm ranting, how much data is reasonable in Access? (Depends on your design... I know!) I'm looking at a job posting, and they use SAP and Office, so Excel/Access etc. Can't help but think a few stored procedures or views inside SAP would be extremely handy.
They're tracking employee ASE certifications... so it's like Students & Classes meets resource management. (Think Banner... <shudder>). Anybody ever use Access to talk to SAP?