Well, this is my third day on this and it is getting very frustrating.

I've tried both method described on this thread. The first imports all the data correctly but then, there is this recordset error and it is impossible to post on the new forum.

With the other method I get errors all over the place while importing the tables, this is one example :

1. Create the database a blank SQL Server database at your web host
2. Run the 'msSQL_server_setup.asp' file to create the database tables, Stored Procedure's etc. on your SQL Server database at your web host
3. Use Enterprise Manager to delete ALL the newly created tables on the SQL Server database created at your web host, just leaving the Stored Procedures.
4. Now on your local machine open your original Access database in Access
1. From the Tools menu in Access, select the 'Upsize Wizard'
2. Choose the Upsize option to 'Create a new database'
3. Choose 'local as your SQL Server and 'Use Trusted Connection'
4. Next select ALL the tables to upsize
5. Leave all other options as default
5. Once your database tables have been upsized using this method, use the 'Export Tool' in Enterprise Manager to upload the tables to the SQL Server database at your web host which you created the Stored Procedures in earlier
6. That should be it

Step by Step by SKYUSB
1) Open your mdb file whit Access
2) Us upsizing Wizard from tools Menu.
3) Upsize Wizard will create your MS SQL data to your Web server.
4) Then Open Query Analyzer and run this script. This Script will create indexs and SPs.

 CREATE  INDEX [Group_ID] ON [dbo].[tblAuthor]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblGrouptblAuthor] ON [dbo].[tblAuthor]([Group_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [User_code] ON [dbo].[tblAuthor]([User_code]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [Username] ON [dbo].[tblAuthor]([Username]) ON [PRIMARY]
GO

 CREATE  INDEX [Ban_ID] ON [dbo].[tblBanList]([Ban_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Address_ID] ON [dbo].[tblBuddyList]([Address_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Author_ID] ON [dbo].[tblBuddyList]([Buddy_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Buddy_ID] ON [dbo].[tblBuddyList]([Author_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblAuthortblBuddyList] ON [dbo].[tblBuddyList]([Buddy_ID]) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [Cat_ID] ON [dbo].[tblCategory]([Cat_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Author_ID] ON [dbo].[tblEmailNotify]([Author_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[tblEmailNotify]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblAuthortblTopicWatch] ON [dbo].[tblEmailNotify]([Author_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Toipc_ID] ON [dbo].[tblEmailNotify]([Topic_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Watch_ID] ON [dbo].[tblEmailNotify]([Watch_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Cat_ID] ON [dbo].[tblForum]([Cat_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_code] ON [dbo].[tblForum]([Forum_code]) ON [PRIMARY]
GO

 CREATE  INDEX [tblCategoriestblForum] ON [dbo].[tblForum]([Cat_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblGroup_ID] ON [dbo].[tblGroup]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Guest_ID] ON [dbo].[tblGuestName]([Guest_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblThreadtblGuestName] ON [dbo].[tblGuestName]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Thread_ID] ON [dbo].[tblGuestName]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Auhor_ID] ON [dbo].[tblPMMessage]([Author_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [From_ID] ON [dbo].[tblPMMessage]([From_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_ID] ON [dbo].[tblPMMessage]([PM_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblAuthortblPMMessage] ON [dbo].[tblPMMessage]([From_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblForum_ID] ON [dbo].[tblPermissions]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblForumtblPermissions] ON [dbo].[tblPermissions]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblGroup_ID] ON [dbo].[tblPermissions]([Group_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Poll_ID] ON [dbo].[tblPoll]([Poll_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Choice_ID] ON [dbo].[tblPollChoice]([Choice_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Poll_ID] ON [dbo].[tblPollChoice]([Poll_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblPollstblPollChoice] ON [dbo].[tblPollChoice]([Poll_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_date] ON [dbo].[tblThread]([Message_date]) ON [PRIMARY]
GO

 CREATE  INDEX [Message_ID] ON [dbo].[tblThread]([Thread_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblAuthortblThread] ON [dbo].[tblThread]([Author_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblTopictblThread] ON [dbo].[tblThread]([Topic_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Topic_ID] ON [dbo].[tblThread]([Topic_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_ID] ON [dbo].[tblTopic]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Poll_ID] ON [dbo].[tblTopic]([Poll_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [tblForumtblTopic] ON [dbo].[tblTopic]([Forum_ID]) ON [PRIMARY]
GO

 CREATE  INDEX [Topic_ID] ON [dbo].[tblTopic]([Topic_ID]) ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpActiveTopics]
(
@AuthorID int,
@GroupID int,
@GroupPerm int,
@dblActiveFrom datetime
)
 AS
SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblTopic.*
FROM tblCategory, tblForum, tblTopic
WHERE ((tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID = tblTopic.Forum_ID) AND (tblTopic.Last_entry_date > GetDate() - @dblActiveFrom))
AND (tblForum.[Read] <= @GroupPerm OR (tblTopic.Forum_ID IN (
 SELECT tblPermissions.Forum_ID
 FROM tblPermissions
 WHERE tblPermissions.Author_ID = @AuthorID OR tblPermissions.Group_ID = @GroupID AND tblPermissions.[Read]=1))
 )
ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpAuthorDesc] AS SELECT tblAuthor.Username, tblAuthor.Author_ID FROM tblAuthor ORDER BY tblAuthor.Author_ID DESC;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpAuthorDetails]
(
@lngUserID int
)
As
SELECT tblAuthor.* FROM tblAuthor WHERE tblAuthor.Author_ID = @lngUserID;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpAuthorLastPostDate]
(
@lngUserID int
)
As
SELECT TOP 1 tblThread.Message_date, tblThread.Author_ID FROM tblThread  WHERE tblThread.Author_ID = @lngUserID ORDER BY tblThread.Message_date DESC;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpBannedIPs] AS SELECT tblBanList.IP FROM tblBanList WHERE tblBanList.IP Is Not Null;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpCategoryAll] AS SELECT tblCategory.Cat_name, tblCategory.Cat_ID FROM tblCategory ORDER BY tblCategory.Cat_order ASC;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpChkUserID]
(
@strUserID VarChar(50)
)
 AS
SELECT tblAuthor.Username, tblAuthor.Author_ID, tblAuthor.Group_ID, tblAuthor.Active, tblAuthor.Signature, tblAuthor.Author_email, tblAuthor.Date_format, tblAuthor.Time_offset, tblAuthor.Time_offset_hours, tblAuthor.Reply_notify, tblAuthor.Attach_signature, tblAuthor.Rich_editor, tblAuthor.Last_visit
FROM tblAuthor
WHERE tblAuthor.User_code = @strUserID;
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[wwfSpCountOfPMs]
(
@lngLoggedInUserID int
)
  AS
SELECT Count(tblPMMessage.PM_ID) AS CountOfPM FROM tblPMMessage


-------------
SKYUSB SOFTWARE & GRAPHICS
www.skyusb.com
www.papaganim.net

Invalid object name 'tblAuthor'.

/forumsql/common.asp, line 499

I tryed but instruction is not very excelent or SQL server is not 100% compatible with Access.

1. download Access file
2. Use Access 2003 Upsize wizard to my local machine
3. logged into my local machine though Enterprise manager and created a .bak file (back up file)
4. then uplaoded to web space and restored as my orginal on my SQL Server.