upgraded versions causing problems

Popular Searches: FrontPage Hosting | FrontPage Templates | FrontPage Training | Free FrontPage

Logged in as: Guest

Printable Version

All Forums >>FrontPage Specific Issues >>FrontPage 2003 >>

Page: [1]

Name:

Message

<< Newer Topic Older Topic >>

bbeckk

Posts: 2
Member since: 6/17/2007

upgraded versions causing problems

I was able to update my ACCESS 2000 database with fromntpage 2000. I have since upgraded to Access 2007 and Frontpage 2003. Everything works fine except the update pages. It give me the following error "Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator."

Any ideas for me? This is what has been written in the edit query area that is no longer working:
UPDATE results
SET User_name='::User_name::'
WHERE Contactf1='::Contactf1::' and Contactl1='::Contactl1::' I used to use no longer work.
It says my code is bad

PLease help
another error I get on the page that was creted and working just find until the upgrades
This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network. The custom query contains errors.

< Message edited by bbeckk -- 7/30/2008 12:23:24 PM >

Report Abuse | Date: 7/30/2008 10:26:10 AM

TexasWebDevelopers

Posts: 7039
Member since: 9/24/2002
From: USA

RE: upgraded versions causing problems (in reply to bbeckk)

Access 2007 uses a different connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

Yours probably looks something like this:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\myFolder\myAccess2003file.mdb"

_____________________________