use a SQLServer 2005 Express database from Access 2007

G

Guest

I have installed SQLServer 2005 Express and Access 2007. I want to use a
SQLServer database (view tables, etc.) from within Access. I have
successfully opened SQL Server management studio express.
When I am in Access and try to open a database "databasename.adp" I get a
message that says "...could not find either Microsoft SQL Server 2005 Desktop
Engine or Microsoft SQL Server installed on your computer. Click OK to
display the Data Link Properties dialog box and log on to a remote server.
If you want to install SQL Server 2005 Express on this computer first, click
cancel, download the software from ..."

What should I do? Is there a way to use control panel (my PC is running
Vista Home Premium) to let Access know that SQL Server 2005 Express is
installed?

Thanks,
Henry
 
S

Sylvain Lafontaine

No: ADP are strictly based on ADO and cannot use ODBC; so you cannot use the
ODBC Data Sources control panel to set up a default connection for an ADP
project.

Follow the indication and reset the connection to the instance that you want
to use from inside the ADP project (ie, after the ADP has opened).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Access 2007 adp project files with SQL Server 2008 Express 3
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
connecting Access 2007 to SQL Server 2005 Express 1
Cannot Delete Using ADO and sqlServer 2005 5
Access and SQLServer Express 2005 3
SQL Express Login Prompt From Access 2007 ADP 1
Access 2007 ADP (Runtime) and SQL Express 2005 6
SQL SERVER 2005 Express Create Table Relationship 3

Top