Any character / delimiter Access 97 / SQL 7

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

Habilidades: Ingeniería, Microsoft Access, MySQL, PHP, Arquitectura de software, Verificación de software, SQL

Ver más: the string problem, string problems, sql data entry form, php data entry form example, ms access form data entry, ms access data entry forms, ms access data entry form examples, ms access data entry form, engineering forms, data entry form design examples, app character design, access database data entry form, ms access sql, problems of data entry, s joe, pizza app, notes editing, name farm, ms sql server setup, data entry SQL , CHARACTER SETUP, access to sql, access sql, access 2000 database, server allow access

Información del empleador:
( 316 comentarios ) United States

Nº del proyecto: #2921738

Adjudicado a:


See private message.

$17 USD en 14 días
(215 comentarios)

2 freelancers están ofertando el promedio de $34 para este trabajo


See private message.

$51 USD en 14 días
(153 comentarios)