Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Error in Dreamweaver CS3 recordset causing crash

Posted on 2008-11-01
6
Medium Priority
?
704 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

688 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