x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Databases and Operating Systems Record is too large on OEINVH / order date

State Not Answered
Replies 6 replies
Subscribers 93 subscribers
Views 3215 views
Users 0 members are here

Browse Forums

271

topics

260

replies

Databases and Operating Systems

764

topics

2k

replies

Financials Suite

1k

topics

3k

replies

General Discussion

2k

topics

10k

replies

Operational Suite

852

topics

2k

replies

Reporting and Analytics

1k

topics

3k

replies

Reports, Macros, and Customizations

877

topics

3k

replies

Sage CRM for Sage 300

183

topics

414

replies

Record is too large on OEINVH / order date

Posted By Ace1 over 8 years ago

Hello,

I am trying to use the order date information in the table OEINVH, but when I try opening the table I get a "record is too large" error message.

Any suggestions will be appreciated. Thanks.

0 MusickInt over 8 years ago

What version of Sage?
What database engine? Pervasive or MsSql?
What client are you using to connect and view the order date?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ace1 over 8 years ago in reply to MusickInt

Version: 2014
DB: MS SQL
Connection through ODBC
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MusickInt over 8 years ago in reply to Ace1

Can you connect to other tables?
What program are you using to connect to ODBC?
Does Sage display the order and order date?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 8 years ago in reply to Ace1

This happens if you view some Pervasive tables in Access.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ace1 over 8 years ago in reply to 49153

Yes, I can connect to all the other tables that I need. I am using the regular ODBC connection. We can see the data in Sage.

We are not using Pervasive but we are using MS Access to build our process.

Thank you all.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 49153 over 8 years ago in reply to Ace1

So I assume you are looking at MS SQL data?
Restrict the number of fields in your query in Access. You cannot open the OEINVH table in Access because there are too many fields in the table, it exceeds what Access can handle.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel