Print Page | Close Window

Access Database

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7470
Printed Date: 06 April 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Access Database
Posted By: prigozu
Subject: Access Database
Date Posted: 21 November 2003 at 6:45pm

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




Replies:
Posted By: lodogg
Date Posted: 21 November 2003 at 11:06pm

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



Posted By: MadDog
Date Posted: 21 November 2003 at 11:13pm
Search The ForumSearch 

-------------
http://www.iportalx.net" rel="nofollow">


Posted By: lodogg
Date Posted: 21 November 2003 at 11:37pm

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



Posted By: prigozu
Date Posted: 22 November 2003 at 3:22pm

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



Posted By: lodogg
Date Posted: 22 November 2003 at 7:06pm

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



Posted By: lodogg
Date Posted: 24 November 2003 at 7:05am

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



Posted By: evilpeppard
Date Posted: 27 November 2003 at 9:15pm
Originally posted by lodogg 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.



Posted By: lodogg
Date Posted: 28 November 2003 at 12:31pm

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



-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: prigozu
Date Posted: 28 November 2003 at 4:39pm

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



Posted By: lodogg
Date Posted: 28 November 2003 at 10:52pm

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



-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: prigozu
Date Posted: 29 November 2003 at 12:08am

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



Posted By: lodogg
Date Posted: 29 November 2003 at 12:16am

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



-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: prigozu
Date Posted: 29 November 2003 at 5:53pm
Lodogg thanks for trying, i won't be able to sleep until i am able to export those 10,000 posts, if anybody can help please post something here


Posted By: lodogg
Date Posted: 29 November 2003 at 11:34pm
That's alot!!!!  I'm sure somebody here can help!!

-------------
Just trying to have some fun and learn in the process.
http://www.lodogg.com - Come have Some Fun


Posted By: Semikolon
Date Posted: 30 November 2003 at 3:17am

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




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net