Upsizing access 2007 db to SQL 2005: ODBC connection failed

[Lost500]

Hi all,
I am trying to upsize a very simple access 2007 db to a SQL 2005 db.

when i run the upsize wizard and select create new database it doesn't make the server connection (the SQL db will be on a different server than the access db)

all of my tables have ID fields (which are my primary if thats bad) but I believe the login has all rights to create and is the system admin.

It really looks like it doesn't try at all so i don't think i'm getting very far in the connection if that helps i don't understand what i might be doing

Any help would be great and if there is a better way to get the database up on the SQL

Thanks!

 

[bburnell]

Have you tried converting the Access DB to 2000/XP/2003 standards and trying that instead? I am wondering if it doesn't recognize the 2007 standard(s).
Hope that helps!
~Brett

--------------------------
Web/.net Programmer & DBA
Central PA