aa*********@gmail.com wrote:
screw front-end back-end
use ACCESS DATA PROJECTs
it is a much better solution; keeps all your data and queries in SQL
Server.. i mean-- one copy of everything is much better than a hundred
copies of everything
Aaron, we know you like ADPs but not everyone is in a position to change
over to them. There have been a lot of posts in this group describing
various problems with them and if you already have a lot of code
invested in an MDB it would be as well to change to a different platform
altogether as it would to re-code everything for an ADP.
To get to an ADP the types of things that would need changing are:
Queries
Would all become SQL Views, I've no problem with that, they are powerful
and are a better way to get data out of a SQL server than an Access
query but again, code invested in Access might include function calls
that would be a pain to implement on SQL Server.
DAO
If used would need converting to ADO, there's certain idiocyncracities
in ADO that would make themselves apparent, like .RecordCount not
working for all recordset types so this would cause a hell of a lot of
debugging for some. If in these circumstances .Recordcount would
generate a runtime error they would be easy to track down but they
don't, they just return -1 causing a logical error that isn't apparent
without stepping through code or knowing what you're looking for.
Temp local tables
You can use something like "create table #Mytemptable" in T-SQL, which
creates a table in the tmp database but unlike a local table in an MDB
it is only available in the scope of the current procedure. Anyone
converting would need to be aware of this.
I haven't investigated this fully, the above I came up with after a
cursory overview so there may be a whole loas of extra gotchas waiting
in the midst.
The biggest worry I would have in converting an application to ADP would
be quoting for it without having done it before to know what's there.
It's like quoting 2 days to wallpaper a room, a day to strip the old
stuff and a day to hang the new stuff. After stripping the old stuff
you're half way into the job put notice the plaster ("dry wall" for my
friends across the pond) is cracked and needs re-doing. You chip away at
this and find the brick wall needs re-pointing or has rising damp. The
two day job suddenly gets a lot longer.