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

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply Topic: Access->SQL: simple question to Guru :-) 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 Edited by ask023

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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 Edited by ask023

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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! Edited by ask023

the boss Members Profile Find Members Posts Senior Member Joined: 19 January 2003 Location: Saudi Arabia Status: Offline Points: 1727	Post Options Post Reply Quote the boss Report Post Thanks(0) Quote Reply 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...


ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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!

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum