473,692 Members | 2,485 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Update Access Memo field from ASP.NET

I'm having difficulty with trying to update a Access memo field through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.
Nov 19 '05 #1
6 2701
Hi Matt,
Try going through this at:-
http://office.microsoft.com/en-us/as...745731033.aspx
** Is it possible do change ur DB to SQL SERVER?
Hope it helps
Patrick

*** Sent via Developersdex http://www.developersdex.com ***
Nov 19 '05 #2
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.

Greetings,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET

I'm having difficulty with trying to update a Access memo field through
an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,

UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.

Nov 19 '05 #3
Unfortunately, I want to be able to use an Access database at this point. I
looked through the comparisons and see how it could work with SQL Server.
But, I still haven't found a solution for Access.

"Patrick Olurotimi Ige" wrote:
Hi Matt,
Try going through this at:-
http://office.microsoft.com/en-us/as...745731033.aspx
** Is it possible do change ur DB to SQL SERVER?
Hope it helps
Patrick

*** Sent via Developersdex http://www.developersdex.com ***

Nov 19 '05 #4
I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would be
greatly appreciated.

Thanks in advance,

Matt

"Wessel Troost" wrote:
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.

Greetings,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET

I'm having difficulty with trying to update a Access memo field through
an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,

UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.

Nov 19 '05 #5
Matt,

Sorry, I'm too busy right now to write an example. However, basically
it's something like this:
- Add a reference to the COM object "Micrsoft ActiveX Data Objects"
- Create an ADODB connection object with the right connection string
(examples can be found through google)
- Recordset = Connection->Open("tablenam e")
- Find the right record
- Update the memofield like: RecordSet("MyFi eld") = "Long text"

I'm not sure that this would even work, but it's the road I would try...

Regards,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 2:55 PM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Re: Update Access Memo field from ASP.NET

I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would
be
greatly appreciated.

Thanks in advance,

Matt

"Wessel Troost" wrote:
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.

Greetings,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET

I'm having difficulty with trying to update a Access memo field through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.


Nov 19 '05 #6
Thanks for the help. I'll give it a try.

"Wessel Troost" wrote:
Matt,

Sorry, I'm too busy right now to write an example. However, basically
it's something like this:
- Add a reference to the COM object "Micrsoft ActiveX Data Objects"
- Create an ADODB connection object with the right connection string
(examples can be found through google)
- Recordset = Connection->Open("tablenam e")
- Find the right record
- Update the memofield like: RecordSet("MyFi eld") = "Long text"

I'm not sure that this would even work, but it's the road I would try...

Regards,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 2:55 PM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Re: Update Access Memo field from ASP.NET

I'm new to ASP.NET and I've never done an update except through an SQL
statement. Could you provide an example of your suggestion? It would
be
greatly appreciated.

Thanks in advance,

Matt

"Wessel Troost" wrote:
Open a read/write recordset on the table. (Not through an SQL query.)
This allows you to update the memo field.

Greetings,
Wessel

-----Original Message-----
From: Matt [mailto:Ma**@dis cussions.micros oft.com]
Posted At: Monday, April 11, 2005 3:57 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Update Access Memo field from ASP.NET
Subject: Update Access Memo field from ASP.NET

I'm having difficulty with trying to update a Access memo field

through
an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT
INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary,

Details,

UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selected item.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.chec ked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.


Nov 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
12966
by: BlackFireNova | last post by:
This concerns an Access 2002 (XP) database. There are two fields, "Notes" (Memo Field) and "Notes Update" on a form (among others) which I am concerned with here. Problem: I need to be able to tell when people have added notes to a record. (this database contains 6000+ records) I want to set it up so that "Notes Update" is updated to the current date whenever someone actually enters data into, or modifies data in, the "Notes"...
0
1629
by: htmlgeek | last post by:
I've beaten my head againts this for two weeks and would appreciate any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000 and then 2003 and received same problems! I've rebuilt pages etc. etc. Insert and update work, but updating of records with data in the memo field seem to crash/corrupt Access--but only on those records. The problem seems to narrow down to updating a record's memo field. It
1
2259
by: Andrew Donnelly | last post by:
I am trying to update a memo field in a table from a form that I have created. The form is unbound, and once the user makes their changes, they have to click the continue button. Once the button is click then, there is some VB code that uses SQL Update to take the information on the form and update the table with the new changes. However, I am having issues with the Memo fields. I have looked at several different posts and have not been...
1
8500
by: Mark Reed | last post by:
Hi All, I'm having a problem with the following code. I've read quite a lot of old posts regarding the issue but none seem to affer a solution. The scenario is. I have a bound form which contains a couple of memo fields. I need to keep some sort of log as to when each update of the memo field occurs so I have locked bot the memo fields on the main form. To edit them, the user double clicks the ememo field which then opens an unbound...
11
1838
by: John | last post by:
Hi I had a working vs 2003 application with access backend. I added a couple fields in a table in access db and then to allow user to have access to these fields via app I did the following; 1. Regenerated the data adapter sqls by running the data adapter wizard and pasting the resulting code into my app. 2. Deleted the data adapter correspond to the relevant access table from the
9
5731
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo field is printed within the detailed area. The problem is, the apllication is not setup properly, thus the users are entering data within the memo field as: location1 1/1/2005 1/1/2006
13
2671
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a records in one front end and leave it unsaved. Edit the same record in the other front end and save the change. Save the change in the first front end - this pops up the Write Conflict message to which I click Save.
0
3236
by: Access Programming only with macros, no code | last post by:
ERROR MESSAGE: Could not update; currently locked by another session on this machine. BACKGROUND I have the following objects: Table1 - HO (which has about 51,000+ records) Table2 - Contact (which has 68,000+ records)
1
2485
thewesties
by: thewesties | last post by:
Could somebody please help me before I dump a gallon of water on my pc! I am very happy to have come across this site on the internet. TheScripts has helped me through so many issues to this point. I have now spent the last 2 days scouring the net for a resolution to my problem. I have a DB with MANY tables, but a transfer of 1 memo field between 2 in particular (tbl_Proposal to tbl_Job) is where my problem is. Nothing is working. The...
0
8611
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9090
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8812
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8810
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7639
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4329
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2984
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2242
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1962
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.