OHSU's Software Forum Forum Index OHSU's Software Forum
Peer support for software.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Welcome
Welcome to OHSU's Software Forum.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, join our community today!

New ADODB.Recordset

 
Post new topic   Reply to topic    OHSU's Software Forum Forum Index -> Access 2007
View previous topic :: View next topic  
Author Message
sgtsortor



Joined: 11 Jul 2008
Posts: 1
PostPosted: Fri Jul 11, 2008 10:30 am    Post subject: New ADODB.Recordset Reply with quote
I've used this code in previous versions of access, but it gives me an error message in 2007.......

Code:
strSQL = "tblPanelSessions"
    Set cnn = CurrentProject.Connection 'sets the connection to current database
    Set rst = New ADODB.Recordset 'sets the recordset to a new ADODB recordset
    rst.Open strSQL, cnn, adOpenStatic, adLockOptimistic, adCmdTable


Quote:
The error message I'm getting is "Compile Error: User-defined type not defined"

HELP! Question
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OHSU's Software Forum Forum Index -> Access 2007 All times are GMT - 7 Hours
Page 1 of 1   

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Chest


Powered by phpBB
Hosted by FreeForums.org