Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Notessql problem with date field

Status
Not open for further replies.
bobalston

bobalston

IS-IT--Management
Feb 11, 2002
3
US


Trying to use Notessql ver 8 to access an R5 database using OCBC from Microsoft Access. Have it working except on one of the tables I get:

ODBC - call failed
Lotus - ODBC Lotus Notes - data value is not a valid date, time or timestamp (#23316).

How can I figure out the field involved?

How can I avoid aborting the import to Access?

This happens on an import or on a make table query in Access using a link to Lotus Notes.

thanks.
 
Status
Not open for further replies.

Similar threads

Sundesa
  • Locked
  • Question
Cisco AIR-CT2504-5 configuration with AIR-CAP2702I-E
Replies
0
Views
655
Sundesa
Sundesa
Sweetworks
  • Locked
  • Question
Help with Agent to Delete Records
Replies
0
Views
67
Sweetworks
Sweetworks
LuckB85
  • Locked
  • Question
Problem with Lotus Notes 6.5 Archive
Replies
0
Views
65
LuckB85
LuckB85
jimcoo
  • Locked
  • Question
outbound mail to addresses with accented characters
Replies
0
Views
62
jimcoo
jimcoo
mhshane
  • Locked
  • Question
Want to create a button in Access 2010 that will use VBA to populate fields in Notes Form
Replies
2
Views
102
mhshane
mhshane

Part and Inventory Search

Sponsor

Back
Top