Print Page | Close Window

DBase works locally but on remote server?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=6806
Printed Date: 31 March 2026 at 4:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: DBase works locally but on remote server?
Posted By: neilmerton
Subject: DBase works locally but on remote server?
Date Posted: 29 October 2003 at 2:58am

hi all,

this is a bit of an odd one: i've created a pretty simple regitration form and the details are entered into an access database. this all works wonderfully on my local machine, but as soon as i try it on my hosting server it returns:

Microsoft JET Database Engine error '80040e14'

The INSERT INTO statement contains the following unknown field name: 'M_TEL'. Make sure you have typed the name correctly, and try the operation again.

now as i said this works perfectly fine on my local machine. does anyone have any idea why it's returning this error when it copied over to the server? the rest of the site works fine and the database updates when someone alters their previously entered info (i.e. old users). for some strange reason people who try to register as a new user get the above error.

things i have tried includes rebooting the server as i thought it might be caching something it shouldn't, but that doesn't help...

i'm pretty new to this whole ASP / Access / Database thing *blush*

hope someone can shed some light on things.

t.i.a!

Neil




Replies:
Posted By: neilmerton
Date Posted: 29 October 2003 at 2:59am

oh, forgot to mention:

M_TEL is a field name in a table for Members. it basically stores their phone number.

and, i've developed locally on Win2k Pro - the web server is running Win NT4 Server (not sure of the SP, think it's 4)

Neil



Posted By: gingerwinger
Date Posted: 29 October 2003 at 5:11am

Have a look here and see if it helps.

http://www.webthang.co.uk/tuts/tuts_asp/gk_errors/gk_errors.asp#9 - http://www.webthang.co.uk/tuts/tuts_asp/gk_errors/gk_errors. asp#9



Posted By: neilmerton
Date Posted: 29 October 2003 at 8:31am

unfortunately there was anything there that looked like it might be causing the server version to error

thnx though



Posted By: Flamewave
Date Posted: 29 October 2003 at 10:26am
Make sure the server has the latest version of  MDAC on it.

-------------
- Flamewave

They say the grass is greener on the other side, but if you really think about it, the grass is greener on both sides.


Posted By: neilmerton
Date Posted: 29 October 2003 at 11:44am

will give that a try on monday - got a couple of days holiday now :)

thnx




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net