[AccessD] Cannot open table in code

Kaup, Chester A kaupca at chevrontexaco.com
Thu Jun 5 12:45:16 CDT 2003


Found solution in knowledge base article 181542. DAO library must have
higher priority than ADO library.
-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Thursday, June 05, 2003 11:35 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Cannot open table in code


Chester,
 
If this is A97 code, then it should be okay if that really is the name
of your table.  However, if this is running in A2K or higher, then you
should specify whether the objects are DAO or ADODB and use the
appropriate constants.
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com] 
Sent: Thursday 2003 Jun 05 11:21
To: accessd at databaseadvisors.com
Subject: [AccessD] Cannot open table in code


The following code will not open the table . Message is type mismatch.
Looks like code I have used before. Probably missing something simple.

Function Add_or_Read_Record() 

Dim myds As Recordset, MyDB As Database 
Set MyDB = CurrentDb 
Set myds = MyDB.OpenRecordset("tbl Last Date in tbl_monthly_inputs",
dbOpenTable) 

End Function 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/8b9d3e23/attachment-0001.html>


More information about the AccessD mailing list