?
Solved

Error in Dreamweaver CS3 recordset causing crash

Posted on 2008-11-01
6
Medium Priority
?
711 Views
Last Modified: 2012-06-27
I am using Dreamweaver CS3 with asp vbs using access.mbd
When I create a recordset in a new page in DW from a table called Section and test this via recordset I get an error message:
Adobe Dreamweaver CS3 has encountered a problem and needs to close.
I replaced the table completely from scratch (same field names and details) but with the same error.
If I use a different table from the same database it runs perfectly.
I carried out a compact and repair.
The table fields are
DestionID
SectionName
DateEntered
So no resevered words I think
Any ideas what can be causing this please?
Many Thanks
John
0
Comment
Question by:johnhardy
  • 3
  • 2
6 Comments
 
LVL 4

Expert Comment

by:justin-clarke
ID: 22857336
It shouldn't just crash the whole app, have you applied the latest updates to CS3? I woul dtry that first as it may just be a bug.
0
 

Author Comment

by:johnhardy
ID: 22857372
Thanks
I went to page http://www.adobe.com/support/dreamweaver/downloads_updaters.html#dw9 
But does not seem to have anything fo English or Europe

Download the Dreamweaver 9.0 updater for the following:
Middle Eastern: Macintosh (42,6 MB)  ReadMe
Afrique du Nord: Macintosh (42,6 MB)  ReadMe
0
 

Author Comment

by:johnhardy
ID: 22857412
Its strange its just that table. I can create recordsets for all other tables in the dbase.
When I created the new section table I did not copy the old table but created it from scratch.
The table opens perfectly in access, I created a form in Access and the data shows correctly
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 22859394
There are no updates for CS3.  Adobe jumped straight to CS4 without patching any of the (numerous) bugs in 3.

I've had limited success (1 of 3 tries) in getting Adobe support to approve me for a free upgrade to CS4, so you can try that route.

From what you describe, it sounds like you may be running into a reserved word that causes the application to crap out.  Try renaming the table (Section) to something else.
0
 

Author Comment

by:johnhardy
ID: 22860773
Thanks Jason,
Your idea about reserved word seems to be correct.
When I looked in Access Help and section was not listed I assumed it could be used.
You did not. Lateral thinking I believe thats called.
I guess thats why your a Genius and I am a Premium Service Member, and glad to be.

Thanks again

John
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 22863729
You won't get a reserved word problem in Access because I don't think Access has any reserved words.  The [table].[column] notation format removes that possibility.

However, accessing Access from a web connection is a different animal altogether.  Reserved words do come into play at that point.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month4 days, 8 hours left to enroll

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question