RFC_READ_TABLE Limit on Number of OPTIONS Lines

[Former Member]

I'm dynamically creating options lines in Access using VBA to read data from a table and create an option line for each record in the table. I've got it working and seems to work well with over 200 options lines. I tried ramping it up to sending about 10,000 options lines and it doesn't work. Does anyone know the limit to the number of options lines that can be passed? I can't find any info on it.

To be clear, I'm not talking about the 72 character limit for an options line, rather the maximum number of options lines that can be passed.

[former_member1001117]

I do not know if there is any limit - I have not encountered any and I posted way over 50.000 option rows ( I think once it was something like 500.000). If you get a system error I would check the package size that you are transfering. Mine is about 500 rows per transfer.