N
NeeNee
I have an Access Project connected to an SQL Server 7 database.
Several of the tables use a text field to hold long descriptions.
Displaying and saving data to the fields had never been a problem
until our staff discovered they had litteraly no limit to the amount
of data they could store in the description fields. Now any record
which has a long description caused the project to crash when it
attempts to display the data.
I modified the source queries by converting the data to a varchar data
type and the data can now be displayed, but the users can't save the
data.
When I look directly at the tables in SQL Enterprise manager, it does
not display the long descriptions, it displays "<long text>".
I have 2 questions;
1. Why when there is a short description, all works well, but when
goes past a certain number of characters, the project crashes.
2. How can I convert the data to be displayed while being connected to
the table directly and still be able to save newly entered data?
Should I create a view instead of a query for the form?
Any help would be appreciated.
Denis
Programmer Canada
Several of the tables use a text field to hold long descriptions.
Displaying and saving data to the fields had never been a problem
until our staff discovered they had litteraly no limit to the amount
of data they could store in the description fields. Now any record
which has a long description caused the project to crash when it
attempts to display the data.
I modified the source queries by converting the data to a varchar data
type and the data can now be displayed, but the users can't save the
data.
When I look directly at the tables in SQL Enterprise manager, it does
not display the long descriptions, it displays "<long text>".
I have 2 questions;
1. Why when there is a short description, all works well, but when
goes past a certain number of characters, the project crashes.
2. How can I convert the data to be displayed while being connected to
the table directly and still be able to save newly entered data?
Should I create a view instead of a query for the form?
Any help would be appreciated.
Denis
Programmer Canada