| Author |
 Topic Search  Topic Options
|
©[CSiP]@Gud 
Mod Builder Group
Joined: 25 April 2003
Location: Denmark
Status: Offline
Points: 53
|
 Post Options
 Thanks(0)
![Quote ©[CSiP]@Gud](forum_images/quote.png "Quote ©[CSiP]@Gud") Quote  Reply
 Topic: Convert database from 2002 to 2000
Posted: 07 May 2003 at 1:48pm |
|
Or help to make username longer... I only Office 2000, so I can't access the the database. I need help...
|
|
Regards
©[CSiP]@Gud
|
 |
Nigelo
Groupie
Joined: 11 October 2002
Location: United Kingdom
Status: Offline
Points: 67
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 May 2003 at 2:23pm |
Yes you can access the data in a 2002 DB with Access 2000 by linking the tables although you cannot directly open the 2002 DB.
If using a v6(2002 DB) source easiest way is to use the Migrator app choosing the Access 2000 version of v7. Just follow instructions and all will run ok.
If using same source and target open a new DB with Access and then LINK all tables of your 2002 source. Then link all tables of your 2000 target noting that the same name tables are automatically renamed having a "_1" appended. Now simply create a series of Append queries for each pair of tables (See the query listing in the Migrator app for the correct sequence).
Do excercise the utmost care when linking the tables making absolutely sure you have a secure backup - just in case!
|
|
Hope this helps
Nigel
|
|
©[CSiP]@Gud
Mod Builder Group
Joined: 25 April 2003
Location: Denmark
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 May 2003 at 4:02pm |
I am not famaly whit access... I think I need help... I just like to get usernames long...
*****
I was looking into it again, and as I see it, it's not only the database, if itis the database.
Could somebody help me whit this? I like to get usernames up to 30 characters
Edited by ©[CSiP]@Gud
|
|
Regards
©[CSiP]@Gud
|
|
xeerex
Senior Member
Joined: 19 November 2002
Location: United States
Status: Offline
Points: 601
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 May 2003 at 9:37am |
I think -borg- has some code functions to limit the username number of characters as well.
If you need an Access 2000 version of the database, I can downgrade it for you and post it here. Just reply to this and let me know.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 May 2003 at 1:32pm |
There are many files that would also need changing and two or three fields in the database.
If you are not familure with ASP and databases then you are better just sticking to the default amount. People can always enter there real name in the real name field which holds around 30 characters.
|
|
|
|
©[CSiP]@Gud
Mod Builder Group
Joined: 25 April 2003
Location: Denmark
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 May 2003 at 1:58pm |
I could get around in ASP, but do the database need any change? I'm quick-learn when I read ASP and done some change, but I'm a slow designer
|
|
Regards
©[CSiP]@Gud
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 May 2003 at 2:24pm |
You need to increase the field sizes in tblAuther for Username and User_code.
Simply open the database in Access select to open the tblAuthor table in design view and in the properties box at the bottom increase the feild size for both the fields.
|
|
|
|
©[CSiP]@Gud
Mod Builder Group
Joined: 25 April 2003
Location: Denmark
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 May 2003 at 3:09am |
xeerex;
If you up to it, I'll like you to make the change in my database. just need to get characters set to 30.
The reason is, that I use my forum to CS clan-member, And most of want they player-names for login; like [CSiP]CultCrusher and [LoLiTa]@FrauILSE...
Copi of my database Thx for help. But my server got some problem, so if it's not answar, please try later again... (I sure it my router making some sh.. on my network-card...)
11-05-2003; I replaced my server, and I'm still looking after what's wrong. The side will be up to evening or tomorrow...
Edited by ©[CSiP]@Gud
|
|
Regards
©[CSiP]@Gud
|
|
