View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default ado connection to access vs. sql server?

Loane,

If you have access to SQL Server, whilst there is an inevitable learning
curve, I think you will find it a much more rewarding development
environment than Access, and that's before you even start on the production
benefits.

Good luck with it.

Bob

"Loane Sharp" wrote in message
...
Thanks RP
It's time to bite the bullet I think ... Doubtless my database design has
flaws, but tweaking this has produced very limited incremental returns.
Cheers
Loane


"Bob Phillips" wrote in message
...
There should be a speed improvement, more functionality, and greater
security and resilence.

Of course, your databse design will be important too.

--