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! 

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

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.

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.

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

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.

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...