Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL-Access char-text conversion Problem. HELP ME!!!!
Please help me with this tough problem. I use Access frontend Form with linked table to SQL server. Problem that Access will display text field with field size set to length of data in each field. it will not use the default field length of SQL table. To edit/append more data to each field on...- Huey001
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
SQL and Access char-text conversion problem!HELP!!!!!!
Please help me with this tough problem. I use Access frontend Form with linked table to SQL server. Problem that Access will display text field with field size set to length of data in each field. it will not use the default field length of SQL table. To edit/append more data to each field on...- Huey001
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
-
Help!!! Data conversion SQL and Access 97 front End
Please help me with this tough problem. I use Access frontend Form with linked table to SQL server. Problem that Access will display text field with field size set to length of data in each field. it will not use the default field length of SQL table. To edit/append more data to each field on...- Huey001
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
DataConversion between SQL7.0 and Access97
Hi all, Please help me with this conversion problem. When displaying 'char' or 'varchar' field from SQL table with Access form + underlied source = SQL odbc linked table. Access will report the length of the field equal the length of the characters stored in SQL field. To add character to Access...- Huey001
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Probem edit SQL fields using Access linked Form to SQL.table.
I have just joined the Forum today, I wish firstly taking this opportunity to say Hello to everyone.Secondly thanks in advance for your helps. I am having problem in editing/appending data to fields stored in SQL table. I use MS Access as the front end with ODBC linked to these table for Edit...- Huey001
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
