Access database - testmy.net resource / tool
Home
Welcome, Guest. Please login or register.
Did you miss your activation email?

  



donations help testmy.net pay for the very high cost to run the site. Any amount is greatly appreciated.
Click to read why...

  spcr
    
News : uglystupid2 Don't look stupid, make sure you keep up-to-date with our rules, please read rules, click here  police December 03, 2008, 03:17:04 AM
testmy.net Broadband  |  Main Forum  |  HELP!  |  Programming and Website Help  |  PHP  |  Topic: Access database Advanced search

Recommended Tests

Click here to run a free Performance Scan
   Test PC Performance:
     Click here to run a free Performance Scan		     Test PC Stability:
     Click here to run a free Registry Scan


Note: The links above are sponsored links
  0 Members and 1 Guest are viewing this topic. « previous next »
Topic Tools Search this topic
 Pages 1 Go Down
Author
Topic: Access database  (Read 1602 times)
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6403



View Profile
« on: April 25, 2005, 07:09:50 PM »
Ok i have a slight problem..  I have developed a site for a dude in washington... it is a photo database site.. It is based on JSP... i know this is the PHP area but they are almost the same.. here is the problem.. I am trying to update the database from the web and I have an autonumber field in the database.. when i try to update it it throws a SQL error.. But when i remove the autonumber field it updates correctly...   Any ideas on how to have it update with the autonumber field in? 
Logged
Swimmer
Vice Admin
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 6403



View Profile
« Reply #1 on: April 29, 2005, 11:18:58 PM »
I got the answer the hard way.. Autonumber on Access is not a real autonumber.. it will update real time like other databases..   Thank you M$ for that lovely feature.. it should be called i++ not auto number
Logged
Print  Pages 1 Go Up
testmy.net Broadband  |  Main Forum  |  HELP!  |  Programming and Website Help  |  PHP  |  Topic: Access database « previous next »
Jump to:  

 
    
testmy.net's forum is proudly Powered by SMF | SMF © 2006-2007, Simple Machines LLC
Bookmark: Del.icio.us    StumbleUpon
 		  

 

 © 1999-2008 testmy.net - Contact - Legal - Facts & FAQs
Page Loading Stats: This forum Page created in 0.083 seconds with 28 queries.