Hi All:
I'm creating a custom installation package of an Access application using Package Wizard in the MS Office developer. The package include the MS Access project .adp file, the SQL server database .mdf file, Access Run-time library and the SQL server data engine. After I build the package, run the Setup.exe and open the MS access project, I got the error message:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
It seems like a connection problem that Access project did not connect to the MS SQL server database. But I only have Access runtime installed and can not configure the connection from File menu from the Access project window.
Does anyone have a clue for this problem? Thanks in advance!
Ellen
I'm creating a custom installation package of an Access application using Package Wizard in the MS Office developer. The package include the MS Access project .adp file, the SQL server database .mdf file, Access Run-time library and the SQL server data engine. After I build the package, run the Setup.exe and open the MS access project, I got the error message:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
It seems like a connection problem that Access project did not connect to the MS SQL server database. But I only have Access runtime installed and can not configure the connection from File menu from the Access project window.
Does anyone have a clue for this problem? Thanks in advance!
Ellen