We recommend that you modify applications that currently use this feature as soon as possible. SQL-DMO also does not support Database Engine features introduced after SQL Server 2000. SQL Server Database Management Objects (SQL-DMO) has been removed from SQL Server 2008 R2 Express and the SQL Server 2008 R2 Feature Pack. Check your registry / file system for SQLDMO.dll versions and register the correct one.Īlso check MSDN " Installing SQL-DMO" because SQLDMO was scheduled for remove after SQL Server 2008 R2:Īvoid using this feature in new development work, and plan to modify applications that currently use this feature. Seems like you've got registered a 32-bit SQLDMO on your system that is being used for connection to the 64-bit instance. I've tested these in sqlcmd and successfully was able to query tables.Ĭan anyone please help me out on this one? I'm not sure what to do next. In the watch list, I can see that ServerName, strSQLUser, and strSQLPwd hold the right values to access the SQL Server.
![access runtime 2010 x64 error access runtime 2010 x64 error](https://cdn.mindmajix.com/blog/images/Screenshot_389-460x232.png)
OServer.Connect ServerName, strSQLUser, strSQLPwd When I select the Debug option, the yellow arrow points to: When I select the server, after a few seconds I get an error:Īutomation error %1 is not a valid Win32 application. When I run the Access application on the 64-bit machine, I have a drop down box to select the SQL Server which holds the various databases.
![access runtime 2010 x64 error access runtime 2010 x64 error](http://www.yohz.com/blogs/wp-content/uploads/2019/07/accdb-01.png)
![access runtime 2010 x64 error access runtime 2010 x64 error](https://miro.medium.com/max/371/1*MdrZZwI7zmwIljOiV9bw1w.png)
I have another machine, Win7 64-bit, running both Access 2010 and SQL Server 2008 (NOT R2) 64-bit. My machine runs Access 2010 and MS SQL Server Express 2008 R2 (both 32-bit, on WinXP) with no problem. Both Access and SQL Server are running locally. I have an application written in MS ACCESS 2007 using VBA, connecting to an SQL Server at the back end.