Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - DBase works locally but on remote server?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

DBase works locally but on remote server?

 Post Reply Post Reply
Author
neilmerton View Drop Down
Newbie
Newbie


Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote neilmerton Quote  Post ReplyReply Direct Link To This Post Topic: DBase works locally but on remote server?
    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

Back to Top
neilmerton View Drop Down
Newbie
Newbie


Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote neilmerton Quote  Post ReplyReply Direct Link To This Post 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



Edited by neilmerton
Back to Top
gingerwinger View Drop Down
Newbie
Newbie
Avatar

Joined: 16 October 2003
Location: United Kingdom
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote gingerwinger Quote  Post ReplyReply Direct Link To This Post Posted: 29 October 2003 at 5:11am
Back to Top
neilmerton View Drop Down
Newbie
Newbie


Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote neilmerton Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
Flamewave View Drop Down
Senior Member
Senior Member
Avatar

Joined: 19 June 2002
Location: United States
Status: Offline
Points: 376
Post Options Post Options   Thanks (0) Thanks(0)   Quote Flamewave Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
neilmerton View Drop Down
Newbie
Newbie


Joined: 13 July 2002
Location: United Kingdom
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote neilmerton Quote  Post ReplyReply Direct Link To This Post Posted: 29 October 2003 at 11:44am

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

thnx

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.