Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / December 2007

Tip: Looking for answers? Try searching our database.

SQL Server 2005 express & DAO

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
derek - 25 Dec 2007 22:13 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.