SQL Server problem

Post Reply

Page 12 3 4 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Topic: SQL Server problem Posted: 22 May 2005 at 3:23pm
	I recently upgraded from Access to SQL Server and when I try to update or add information, I get the following error message, ADODB.Recordset error '800a0cb3' Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /forum2/forum/post_message.asp, line 746 All of my tables and post are there and are in sync All of the tables are owned by 'dbo' I upgraded using the Access Upsize Wizard I have already visited the particular forum dedicated to this subject above, but none of their solutions are working for me. Can anyone help me out here?
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 3:26pm
	im not sure but i think i had a simular problem once when doing the upgrade for a client , but im not to sure on the spacifics but the best way to do so (i found it to work) is to upsize to a local SQL server then use DTS/Enterprise Manager DTS and sending the tables in correct order. take a look at the main topic on the sequance i used on one i did the other day. its the only way ive managed to do so. the other way is to upsize to local server and then take a back up, and restore on the webserver

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 3:32pm
	I upsized from Access to a local Machine version of SQL Server. Then I transferred that information using the third option in the import process -- Copy objects and data between SQL Server databases -- When I did that, it said complete, but not all objects were transferred. What is the "order" (step by step) in which I am supposed to upload the content? Do I do one table at a time? The method I described is the only way the information would upload, but I still can't update.
	Man Know Thyself

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 4:52pm
	I found this article on Upsizing from Access to SQL Server. It is for an older database but I wonder if the same rules apply. Here is the link http://www.windowsitpro.com/Article/ArticleID/6133/6133.html?Ad=1 Can anyone tell me if this ok? I would personally like to know how to determine the dependency order for the access tables. It says to upload in depency order but I am confused as to how I should approach this.
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 5:08pm
	the order for the forum that i used was forum categories table forum forum table forum author table forum topics table forum threads table then i think it was forum Private message table then i sent the other tables all in one go the first 5 i did one by one. then i sent the others all together. i had amended tables within the tranfer (not created or anything).. you do this by clicking tranform within the dialog box.

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 6:11pm
	Should I use the upsize wizard to create the tables and relationships, then use the SQL Server's Import tool to upload the data?
	Man Know Thyself

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 6:20pm
	i used the upsize wizard within MS Access 2003 . then i think just uploaded straight from MSSQL server to MSSQL server without adding first.. i think...

imhotep Members Profile Find Members Posts Groupie Joined: 29 June 2003 Location: United States Status: Offline Points: 67	Post Options Post Reply Quote imhotep Report Post Thanks(0) Quote Reply Posted: 22 May 2005 at 6:29pm
	I am using office XP. Is there a significant difference in how this is carried out between versions? I know I am asking far too many questions, I just have been trying to get this right all weekend. So when we are talking about uploading one table at a time, this is in SQL Server right? I mean, from SQL Server to SQL Server? Should we load the table structure and data all together from Microsoft Access to the local MSSQL Server and then load each table individually? Do we just upload the structure and relationships into the local MSSQL Server Database and then from there import into the server on the host computer AND THEN import the data seperately and do the process for each table individually Edited by imhotep - 22 May 2005 at 8:36pm
	Man Know Thyself

Post Reply	Page 12 3 4 >

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