HELP HELP HELP

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
prigozu Members Profile Find Members Posts Newbie Joined: 09 January 2003 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote prigozu Report Post Thanks(0) Quote Reply Topic: HELP HELP HELP Posted: 05 December 2003 at 8:26am
	Hi Guys, I am trying to import the forum posts from Access to SQL but i can't import any members into SQL because the username Administrator and guest is there as a default and it won't let me overwrite them, can anybody tell me how to delete them from the forum. Thank you

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 05 December 2003 at 9:00am
	First, "Help Help Help" in the Subject line is not letting anyone know what your problem is so you might want to try having a more descriptive Subject. To your problem, if you do the import you need to enable Identity Insert on the SQL side and overwrite desination data. You can also just leave the current Administrator account and update it manually skipping the one from your access database. If you are using DTS I recommend the first as it is just one click to enable identity insert.
	Blog \| MPG Tracker

simpson Members Profile Find Members Posts Groupie Joined: 31 July 2002 Status: Offline Points: 127	Post Options Post Reply Quote simpson Report Post Thanks(0) Quote Reply Posted: 05 December 2003 at 9:01am
	Maybe if you changed your headline to something which has something to do with your problem, people will help. How can you expect people to view a topic called "HELP HELP HELP"!!! Please edit it ASAP! PS. Have you done a search on "access to sql"?

prigozu Members Profile Find Members Posts Newbie Joined: 09 January 2003 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote prigozu Report Post Thanks(0) Quote Reply Posted: 05 December 2003 at 12:19pm
	Sorry for the subject guys, i was able to solve the sql problem, thanks for your help.

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

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.