| Author |
 Topic Search  Topic Options
|
lodogg 
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
 Post Options
 Thanks(0)
 Quote  Reply
 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
|
|
|
 |
prigozu
Newbie
Joined: 09 January 2003
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
prigozu
Newbie
Joined: 09 January 2003
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
prigozu
Newbie
Joined: 09 January 2003
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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
|
|
lodogg
Groupie
Joined: 22 August 2003
Location: United States
Status: Offline
Points: 161
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 November 2003 at 11:34pm |
That's alot!!!! I'm sure somebody here can help!!
|
|
|
|
Semikolon
Senior Member
Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
|
Post Options
Thanks(0)
Quote Reply
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..
|
|
