Any character / delimiter Access 97 / SQL 7

Completed Posted Apr 2, 2003 Paid on delivery
Completed Paid on delivery

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).

## Deliverables

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.

## Platform

Any of the following: WIndows 95/98/NT/2000

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing SQL

Project ID: #2921738

About the project

2 proposals Remote project Active Apr 2, 2003

Awarded to:

sawamu

See private message.

$17 USD in 14 days
(215 Reviews)
5.9

2 freelancers are bidding on average $34 for this job

finecodervw

See private message.

$51 USD in 14 days
(153 Reviews)
6.2