Skip to Content
avatar image
Former Member

RFC_READ_TABLE Limit on Number of OPTIONS Lines

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 11 at 07:55 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded