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...