Web Wiz Support and Community Forums : Access Database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 13:41:21 +0000 Sun, 30 Nov 2003 03:17:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7470 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access Database : the forums run access v 2000.....]]> https://forums.webwiz.net/access-database_topic7470_post38861.html#38861 Author: Semikolon
Subject: 7470
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..

]]> Sun, 30 Nov 2003 03:17:12 +0000 https://forums.webwiz.net/access-database_topic7470_post38861.html#38861 <![CDATA[Access Database : That&#039;s alot!!!! I&#039;m...]]> https://forums.webwiz.net/access-database_topic7470_post38857.html#38857 Author: lodogg
Subject: 7470
Posted: 29 November 2003 at 11:34pm

That's alot!!!!  I'm sure somebody here can help!!]]> Sat, 29 Nov 2003 23:34:52 +0000 https://forums.webwiz.net/access-database_topic7470_post38857.html#38857 <![CDATA[Access Database : Lodogg thanks for trying, i won&#039;t...]]> https://forums.webwiz.net/access-database_topic7470_post38835.html#38835 Author: prigozu
Subject: 7470
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]]> Sat, 29 Nov 2003 17:53:04 +0000 https://forums.webwiz.net/access-database_topic7470_post38835.html#38835 <![CDATA[Access Database : Well I&#039;m running office XP...]]> https://forums.webwiz.net/access-database_topic7470_post38702.html#38702 Author: lodogg
Subject: 7470
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

]]> Sat, 29 Nov 2003 00:16:34 +0000 https://forums.webwiz.net/access-database_topic7470_post38702.html#38702 <![CDATA[Access Database : I did exactly what you&#039;re...]]> https://forums.webwiz.net/access-database_topic7470_post38701.html#38701 Author: prigozu
Subject: 7470
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

]]> Sat, 29 Nov 2003 00:08:45 +0000 https://forums.webwiz.net/access-database_topic7470_post38701.html#38701 <![CDATA[Access Database : Are you exporting to a new database?...]]> https://forums.webwiz.net/access-database_topic7470_post38698.html#38698 Author: lodogg
Subject: 7470
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



Edited by lodogg]]> Fri, 28 Nov 2003 22:52:53 +0000 https://forums.webwiz.net/access-database_topic7470_post38698.html#38698 <![CDATA[Access Database : Hi lodogg, I follow your instruction...]]> https://forums.webwiz.net/access-database_topic7470_post38682.html#38682 Author: prigozu
Subject: 7470
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

]]> Fri, 28 Nov 2003 16:39:54 +0000 https://forums.webwiz.net/access-database_topic7470_post38682.html#38682 <![CDATA[Access Database : Nota problem it will kick up errors...]]> https://forums.webwiz.net/access-database_topic7470_post38646.html#38646 Author: lodogg
Subject: 7470
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

]]> Fri, 28 Nov 2003 12:31:54 +0000 https://forums.webwiz.net/access-database_topic7470_post38646.html#38646 <![CDATA[Access Database : lodogg wrote: Try this little...]]> https://forums.webwiz.net/access-database_topic7470_post38490.html#38490 Author: evilpeppard
Subject: 7470
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

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

]]> Thu, 27 Nov 2003 21:15:58 +0000 https://forums.webwiz.net/access-database_topic7470_post38490.html#38490 <![CDATA[Access Database : Try this little write upI just...]]> https://forums.webwiz.net/access-database_topic7470_post37696.html#37696 Author: lodogg
Subject: 7470
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

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

 

Thanks,

Lo

]]> Mon, 24 Nov 2003 07:05:13 +0000 https://forums.webwiz.net/access-database_topic7470_post37696.html#37696