Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rocksteer
Yak Posting Veteran
69 Posts |
 Posted - 2014-01-10 : 06:27:36
|
| Hi,I have tried using the upsizing wizard to upload an Access 2003 table to a SQL Server 2008 database.I have given the mixed security ODBC USER DSN that I am using SA authority.I also created another ODBC USER DSN using my windows login (which also has SA authority on the server)I get connection failure.Why is this failing? I remember upsizing years ago from Access with no problems.I need to create tables from a remote replicated server that I have only read only access and there are hundreds of fields in those tables. To create each of those tables manually is really going to be a chore, and I risk making many errors in the process.Any help |
|
|
|
|
|
Upsizing Fails Access 2003 to SQL Server 2008