Problem: Currently using double-quotes as SQL field delimiters. New requirement demands that essentially any ASCII character be entered into field in SQL Server table. Existing form has problems with an entry such as [4"5fh!+] because the double-quote in the string is interpreted as a delimiter. Solution: Seeking MS Access 97 form for handling data entry of any character string into SQL Server 7 database. Examples of entries that must work include: - Joe's "Pizza Emporium" - +=348&6 - "Well'2987# Notes: I can modify the code for my app once I receive it, and therefore request that the problem be addressed by coding for a fictional example, as follows: 1) Access 97 Form called frmCorn and frmCornEntry attached to table tblCorn in SQL Server 7 database called Farm. 2) frmCorn displays all entries (* from tblCorn). 3) frmCornEntry provides for data entry and editing of entries in tblCorn. 4) SQL fields: - CornID int Identity PK - Corntxt1 varchar (15) - must handle any character - Corntxt2 varchar (15) - must not allow null values - CornNotes 5) frmCornEntry must provide error handling/message when error occurs - for both string probs (Corntxt1) and null (Corntxt2).
Access 97 database file (mdb) with forms and access to code in design view. Should be attached by default to table/database referenced by name listed in description. I will handle actual SQL table setup, etc.
Any of the following: WIndows 95/98/NT/2000