Hi - I'm not sure if this is the correct forum for this question. If it
isn't I'd be grateful if someone could direct me to the right one.
Meanwhile, here goes ...
I'm converting an old Access app to SQL, and upgrading the front end to
Access 2007. The app uses (a lot!) of DAO code. I was pretty much resigned
to the idea of having to rewrite it all as ADO, but I read that the main
Data-access protocol in A2007 has reverted to DAO. Is this true???
Preliminary experiments with DAO and ODBC are encouraging. Obviously I need
to change a lot of stuff to Stored procedures etc. but it all seems to work
quite well.
Seems that running SP's from DAO is very tricky and it is necessary to use
the RDO layer to make them work. But the code for that is very simple, and
they seem to work very well. Anyone have any comments on this???
Lastly can someone recommend a good site to learn more about controlling no.
of connections to the database with DAO?
Thanks,
Derek
Russell Fields - 26 Dec 2007 02:21 GMT
Derek,
Here is a Technet article on SQL Server 2005 and DAO, which has one stored
procedure example:
http://technet.microsoft.com/en-us/library/bb188204.aspx
Also, here is the Access Team blog (one of the entries) so this might be a
good place to go for info.
http://blogs.msdn.com/access/archive/2006/04/25/better-looking-forms-reports-fas
ter.aspx
Hope it helps,
RLF
> Hi - I'm not sure if this is the correct forum for this question. If it
> isn't I'd be grateful if someone could direct me to the right one.
[quoted text clipped - 19 lines]
> Thanks,
> Derek