Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 How to change values in Access ?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 26 November 2004 :  06:39:01  Show Profile
Itīs not directly about Snitz, but I have another Access file where I want to change some values, but I donīt know how.

Thereīs one article in the database called "articleid1", I want to change this to articleid100", but I canīt since itīs related to other tables, how do I change that?

I can mail the database to whomever can help.

Thanks

Edited by - ruirib on 26 November 2004 07:09:13

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 26 November 2004 :  07:08:48  Show Profile  Send ruirib a Yahoo! Message
May I ask why the name matters? Why would you want to change it?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

wii
Free ASP Hosts Moderator

Denmark
2632 Posts

Posted - 26 November 2004 :  07:23:20  Show Profile
Well, I had a conflict with another page with the same articleid, but I fixed it.

Feel free to delete this topic.
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 26 November 2004 :  08:01:51  Show Profile  Send pdrg a Yahoo! Message
but before you do - you would need to create a record with article100 (suggest you make it a copy of article1), update all the related tables, then delete your article1 entry. This is the manual way to do it, but you could write a script or rely on cascading updates - without more detail can't tell you which!

hth
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.49 seconds. Powered By: Snitz Forums 2000 Version 3.4.07