Upsizing Access 2000-SQL Server2005

[BillD]

I am running Windows 2000Pro-SP4, Office 2000Pro, Downloaded SQL Server 2005
Express and management tools for SQL server express.

A prerequisite seems to be windows XP Professional. I have windows XP Media
Center Edition. I could not find info if this is OK, so I downloaded it and
it seem to install OK.
After trying almost everything to upsize my current database back end with
tables only, I created a new database from scratch in Access 2000. Only one
table in the database. No forms, queries or reports. The table has an ID
field as the primary key and 3 other fields; LastName, FirstName and
MiddleName.
I tried the upsizing wizard; I get the same response. ERROR-"Table was
skipped, or Export failed". I am stumped because I don't know SQL. I can't
see a database anywhere that has been created. Would the upsizing wizard not
cause a database to be created in some form even if there were errors.
I don't know why I can't create a database in SQL. If I have created one, I
can't find it anywhere on this computer. Microsoft should consider renaming
The Upsizing WIZARD to the Upsizing DUMMY. I don't know SQL so I have an
excuse.


BillD - This can't really be that difficult.

 

[Rick Brandt]

I am running Windows 2000Pro-SP4, Office 2000Pro, Downloaded SQL
Server 2005 Express and management tools for SQL server express.

A prerequisite seems to be windows XP Professional. I have windows XP
Media Center Edition. I could not find info if this is OK, so I
downloaded it and it seem to install OK.
After trying almost everything to upsize my current database back end
with tables only, I created a new database from scratch in Access
2000. Only one table in the database. No forms, queries or reports.
The table has an ID field as the primary key and 3 other fields;
LastName, FirstName and MiddleName.
I tried the upsizing wizard; I get the same response. ERROR-"Table was
skipped, or Export failed". I am stumped because I don't know SQL. I
can't see a database anywhere that has been created. Would the
upsizing wizard not cause a database to be created in some form even
if there were errors.
I don't know why I can't create a database in SQL. If I have created
one, I can't find it anywhere on this computer. Microsoft should
consider renaming The Upsizing WIZARD to the Upsizing DUMMY. I don't
know SQL so I have an excuse.


BillD - This can't really be that difficult.

Forget the wizard. Create the tables yourself using the tools you just
installed. Then YOU are making the design decisions instead of some tool and
you might even learn some new things in the process. Once built you can easily
append your data into them.

 

[BillD]

Thanks for the advice. I will try and learn to use the tools.
BillD

 

[Arvin Meyer [MVP]]

Actually building the tables in SQL-Server isn't that much different from
building them in Access.

 

[BillD]

That's encouraging.
Thanks, Bill D

Actually building the tables in SQL-Server isn't that much different from
building them in Access.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tony Toews [MVP]]

I am running Windows 2000Pro-SP4, Office 2000Pro, Downloaded SQL Server 2005
Express and management tools for SQL server express.

It may very will be that the Access 2003 and prior versions of the
Upsizing Wizard can't even see SQL Server 2005 Express. But I'm
guessing.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

There is a new tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/default.mspx However
it only supports SQL Server 2005.

If you are using SQL Server 2000 then you could install SQL Server
2005 Express on your system and then run some SQL Server utilities to
create schema scripts which you could then execute on SQL Server 2000.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[BillD]

I have downloaded the SSMA and will give it a try.
I have not been able to create or import a table so far.

Thanks for the great info.
BillD