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
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
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
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
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
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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07