C
Cathy E.
Have Access 2002 database, trying to write back to a Notes
database via SQL Driver. Have 30 fields in the query I’m
writing back to Notes, have established the unique
identifier. Query hangs up when writing back to Notes.
After cutting the query back to just one export field, it
worked. So I added the next field. OK so far. Got a hang
up at 3 fields, installed Windows Service Pack 4 and was
able to add 4 fields. Through all this testing, action
queries taking 6+ minutes to run, though in dataview
results are instant.
Why does the process break down after 4 fields, is Notes
not able to handle? 2500+ records, simple data such as
company name, phone, $ amount of purchase order, date,
name of buyer, order number, etc. No memo fields.
In the past I updated these Notes records through a 3rd
party product called datalink. Datalink is no longer
supported and SQL Driver is the recommended replacement.
Can't get past the errors, though. In the datalink
scenario, I would delete all records in the Notes
database, then run the transfer and it would insert the
records. Took less than a minute, file got as high as
4000+ records, yet no problems.
With the SQL/ODBC connection, I can't even get it to where
it will accept more than 4 of the fields.
If there's a better way than SQL/ODBC, please advise.
Datalink will no longer be an option in the near future
due to system changes.
Thank you.
database via SQL Driver. Have 30 fields in the query I’m
writing back to Notes, have established the unique
identifier. Query hangs up when writing back to Notes.
After cutting the query back to just one export field, it
worked. So I added the next field. OK so far. Got a hang
up at 3 fields, installed Windows Service Pack 4 and was
able to add 4 fields. Through all this testing, action
queries taking 6+ minutes to run, though in dataview
results are instant.
Why does the process break down after 4 fields, is Notes
not able to handle? 2500+ records, simple data such as
company name, phone, $ amount of purchase order, date,
name of buyer, order number, etc. No memo fields.
In the past I updated these Notes records through a 3rd
party product called datalink. Datalink is no longer
supported and SQL Driver is the recommended replacement.
Can't get past the errors, though. In the datalink
scenario, I would delete all records in the Notes
database, then run the transfer and it would insert the
records. Took less than a minute, file got as high as
4000+ records, yet no problems.
With the SQL/ODBC connection, I can't even get it to where
it will accept more than 4 of the fields.
If there's a better way than SQL/ODBC, please advise.
Datalink will no longer be an option in the near future
due to system changes.
Thank you.