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

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 how to rename		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ez4arab
Junior Member

479 Posts
Posted - 29 August 2003 :  12:45:02  Show Profile  Visit Ez4arab's Homepage
I want to rename field name in database and keep information in the filed without change or delete

Field name
MEMBER_TASK to M_TASK

[ALEART]
MEMBERS_CONFIG

RENAME:MEMBER_GET TO M_TASK
[END]
Ez4arab web site Ez4arab |

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 29 August 2003 :  19:21:23  Show Profile  Send ruirib a Yahoo! Message
I'm not sure but I don't think there is a dbs syntax for that. Why noy just open the DB and do it with Access? Or use Table Editor?

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

Ez4arab
Junior Member

479 Posts
Posted - 31 August 2003 :  11:30:56  Show Profile  Visit Ez4arab's Homepage
quote:
Originally posted by ruirib

I'm not sure but I don't think there is a dbs syntax for that. Why noy just open the DB and do it with Access? Or use Table Editor?

i can not open my database because it is out of root, Access conn't opne it.
table editor, i did not know how to use it
Ez4arab web site Ez4arab |
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 31 August 2003 :  16:16:55  Show Profile  Send ruirib a Yahoo! Message
Table editor has a good readme and it's easy to install. I would advise you to install it, its pretty useful.

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

Ez4arab
Junior Member

479 Posts
Posted - 02 September 2003 :  13:22:01  Show Profile  Visit Ez4arab's Homepage
I test the Table editor As i sad my database out of root
Ez4arab web site Ez4arab |
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 02 September 2003 :  13:44:42  Show Profile  Send ruirib a Yahoo! Message
It doesn't matter whether the DB is out of root or not. My DBs are always out of root and Table Editor works perfectly with them.

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

Ez4arab
Junior Member

479 Posts
Posted - 02 September 2003 :  16:56:56  Show Profile  Visit Ez4arab's Homepage
I don't know how can you explain to me if I put full path of the database it cannot find the database

my site
-- html
--- table editor folder
-- database
--- my database here e.g. x.mdb

I write c:\databse\x.mdb
Table editor not accept this path
Ez4arab web site Ez4arab |
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 02 September 2003 :  17:01:48  Show Profile
if you are being hosted on a server, surely that is not the physical path to your database folder.
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Ez4arab
Junior Member

479 Posts
Posted - 02 September 2003 :  17:15:12  Show Profile  Visit Ez4arab's Homepage
So is there any solution
Ez4arab web site Ez4arab |
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 02 September 2003 :  17:46:54  Show Profile  Send ruirib a Yahoo! Message
My databases are always above my root web folder. What I do when I add them to Table Editor is to specify the path like this


	"../../database/myDB.mdb"


This works for me.

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

Nikkol
Forum Moderator

USA
6907 Posts
Posted - 02 September 2003 :  17:47:03  Show Profile
yes, use the correct path to your database. if you do not know it you can use the whereami file in the tools zip file.
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Edited by - Nikkol on 02 September 2003 17:47:36
Go to Top of Page

Ez4arab
Junior Member

479 Posts
Posted - 03 September 2003 :  11:59:35  Show Profile  Visit Ez4arab's Homepage
Finally, it works fine thanks ruirib & Nikkol
Ez4arab web site Ez4arab |
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 03 September 2003 :  19:02:37  Show Profile  Send ruirib a Yahoo! Message
Glad you got it working .

Snitz 3.4 Readme | Like the support? Support Snitz too
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.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07