SQL 2008 Express and Access project problem
Microsoft SQL Server Database Wizard in Access and after clicking on next to create the database I get this message:
"The new database wizard does not work with the version of Microsoft SQL Server to which you Access project is connected. See the Microsoft Update Web site for the latest information an downloads"
Tried this here but it does not work http://www.access-programmers.co.uk/...d.php?t=182076
I can't find any solution to the problem so far. Any ideas why and how to solve this problem?
Also when connecting Access to a SQL database what is better ADP or going trough an ODBC connector? I'm new at working with SQL and seem to like ADP because I can create my tables within Access instead of creating tables outside of Access and then linking them through the ODBC connector. Need some feedback here...
"The new database wizard does not work with the version of Microsoft SQL Server to which you Access project is connected. See the Microsoft Update Web site for the latest information an downloads"
Tried this here but it does not work http://www.access-programmers.co.uk/...d.php?t=182076
I can't find any solution to the problem so far. Any ideas why and how to solve this problem?
Also when connecting Access to a SQL database what is better ADP or going trough an ODBC connector? I'm new at working with SQL and seem to like ADP because I can create my tables within Access instead of creating tables outside of Access and then linking them through the ODBC connector. Need some feedback here...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I should have said that I'm using SQL 2008 Express.
Hi,
if you are talking about the upsizing wizard I would assume it has the same reason. But 2008 and 2005 have no problem to run on the same computer, so why not install a 2005, use the upsizing wizard and then transfer the SQL Server objects using SQL Server Management Studio to 2008?
In the end you only need to relink the tables and so on to 2008 in Access.
Cheers,
Christian
if you are talking about the upsizing wizard I would assume it has the same reason. But 2008 and 2005 have no problem to run on the same computer, so why not install a 2005, use the upsizing wizard and then transfer the SQL Server objects using SQL Server Management Studio to 2008?
In the end you only need to relink the tables and so on to 2008 in Access.
Cheers,
Christian
ASKER
Thank you for your answer...I may start then with ACCDB and ODBC
The blog does say that "Access 2007 ADP’s will run against SQL Server 2008"
Why am I getting this message then?
"The new database wizard does not work with the version of Microsoft SQL Server to which you Access project is connected. See the Microsoft Update Web site for the latest information an downloads"