Hi guys

I am using the web wiz forum version 7 with access database and my database is about 11mb and i am getting worried that it might get corrupted because i heard that access database gives you problem after it reaches 10 mb so i would like to know if that's true and how big can it gets without giving you problem. i want to move to sql server but i don't know anything about it but i rather stay with access but i don't want the database to get slower or get corrupter, what's your advise

I say go to sql eventually!  I'm working on the easiest process on doing this hopefully I can get some step by step procedure for everyone soon!  May be you could run a compact and repair to try to shrink the database alittle bit.  I'm not sure what the best method would be?  Just a few thoughts..

Thanks

Lo

I searched the hell out of this site and still does not give a good explanation on how to do the import.  there is bits and pieces here and there but still the documentation has not been done for us newbies.  You and the other amins are pros at the forums and *asp.  as you can see the struggle I'm going through..  I'm not trying to be rude what so ever just try to understand the NEWBIES MIND

http://forums.webwiz.net/forum_posts.asp?TID=7448&PN=1 - http://forums.webwiz.net/forum_posts.asp?TID=7448&a mp;a mp;PN=1

Maybe you have some answers for my above post?

Thanks

Lo

PS

After this is all said and done I'm going to create a step by step write up with screen prints on how to do this procedure and then everyone can point them there......

Thanks for the reply guys, i was able to get the web wiz SQL v 7.6 up and running now my problem is to move all the data from access to sql, i have about 8,000 posts, can anybody help.

Thank you once again

http://forums.webwiz.net/forum_posts.asp?TID=7448&PN=2 - http://forums.webwiz.net/forum_posts.asp?TID=7448&a mp;PN=2

Well take a look at this post and see if you can help me piece together the steps on how to do this  Maybe with these posts I can write up some step by step documentation on hot to do this procedure!!!!!!!!!!!!  I found at the end when I ran the upsizing tool and created a brand new database inside of SQL then I used the 'SQL_server_connection.asp' file and pointed it to the new database and it works great!  Now the only problem is it has less stored procedures this way and I'm not sure if this is the best or fastest method on conversion???? 

Keep me posted on what you find out through your testing!!!!

Thanks

Lo

Try this little write up I just made.  If the administrator would like something else done to it I can add changes or if some one else would like to add let me know.  This documentation needs to be made?  There are too many newbies out there such as myself!!  Try this export method and let me know if all the 8,000 go over!!

http://www.lodogg.com/upsizing.htm - http://www.lodogg.com/upsizing.htm

-boRg-  Let me know if this OK.  I will delete the link if you want me too.

Thanks,

Lo

lodogg wrote: Try this little write up I just made.  If the administrator would like something else done to it I can add changes or if some one else would like to add let me know.  This documentation needs to be made?  There are too many newbies out there such as myself!!  Try this export method and let me know if all the 8,000 go over!! http://www.lodogg.com/upsizing.htm - http://www.lodogg.com/upsizing.htm -boRg-  Let me know if this OK.  I will delete the link if you want me too.   Thanks, Lo

Thanks for taking the time to create these instructions.  I tried them and it seemed to work for me.  When I ran the setup script, it showed a number of errors, but everything appears to be there.

Thanks again.

Not a problem it will kick up errors because the tables are already imported but you need to run it to create the stored procedures in the SQL database.

Thanks

Lo

Hi lodogg,

I follow your instruction and after the last step when i clicked finish i get the upsize wizard report and on the report it says

Erros
table: tblactiveuser
table was skipped, or export failed

table: tblauthor
table was skipped, or export failed

table: tblbanlist
table was skipped, or export failed

table: tblbuddylist
table was skipped, or export failed

Are you exporting to a new database?  Was the database in use while you were doing the export?  I copied the database to another location before I started the export I guess I should have mentioned that  I would make sure it was not in use??  Try it again and copy your *.mdb to another location and make sure your creating a brand new SQL database.

Thanks,

Lo

I did exactly what you're telling me but i am still getting the same errors, i am trying to export from forum access version 7 to sql version 7.6, do you think the problem might be cause of the version, and by the way i am on office 2003.

Thanks Man

Well I'm running office XP and my database is a access 2000 database and I'm upsizing to a sql 2000 database so that could very well be the problem.  I would for sure ask some of the experts around here.  Sorry I can't help past this.  I just barley got by with what i did.  But please if you come up with some info let me know and I will add it to this htm page so others won't have to go through this pain

Thanks

lo

the forums run access v 2000..

access in office xp creates access 2000 databases and i think that access 2003 creates 2003 databases, but if you open the forumsdatabase in 2003 its still in 2000 format..