Web Wiz Forums - Access->SQL: simple question to Guru :-)

Print Page | Close Window

Access->SQL: simple question to Guru :-)

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=4833
Printed Date: 02 April 2026 at 2:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access->SQL: simple question to Guru :-)

Posted By: ask023
Subject: Access->SQL: simple question to Guru :-)
Date Posted: 07 August 2003 at 10:13am

Hello,

I just moved Access 2000 DB (7.01) into MS SQL 2000 according Bruce recommendations:

1) Upsize DB through Access Upsize wizard
2) Run msSQL_server_setup.asp to created relations/etc

Currenly SQL DB work fine , but I noticed that "Administrator" user was added again + all Groups were added again (so I have 2 Guest, 2 Groupie, etc)

I just deleted unnecessary groups and "Administrator" user, but could you tell me please, are there any other issues which shall be changed manually??

Thank you in advance,
Best wishes,
Sergey

Replies:

Posted By: ask023
Date Posted: 08 August 2003 at 4:11am

Dear Colleagues!
I can't belive that no one had Access-SQL migration...
Please, help me to find what else I should manually fix after migration. It's really important for Board safety...

Thank you very much in advance!
Best wishes,
Sergey

Posted By: ask023
Date Posted: 08 August 2003 at 12:18pm

PS Recenly I migrated my forum, and "Administrator"/"letmein" user was available at open Internet forum for 3 weeks! So, it's really
important to check what else shall be fixed after ACCESS->SQL migration...

Thank you for any ideas!

Posted By: the boss
Date Posted: 08 August 2003 at 3:29pm

delete the duplicate administrator and guest account

delete the duplicate groups which are EMPTY .. so make sute the one u r deleting got no members in it.. ensure the groups permissions, board configuration and other stuff is same as u expected...

-------------
http://www.web2messenger.com/theboss">

Posted By: ask023
Date Posted: 10 August 2003 at 1:19pm

Thank you for reply! I'll check all configuration items...
Probably anyone have some specific examples, what may be wrong after Access-> SQL migration?

Thank you!