Hey all -
I'm going to be migrating an application from Access 2002 to Access 2010 in the near future, as we're running into problems with this app on Win7 machines.
First step - get connectivity working.
I've mapped a folder named 'SERVER' on my local machine to W:. Inside this folder sits another db: Custom_Reports.mdb. In my VBA startup module, I'm attempting to connect to this database. When I run this line:
The application crashes, where strCustReportsLocation = 'W:\Custom_Reports.mdb". If I set strCustReportsLocation to C:\Server\Custom_Reports.mdb" instead, it works.
I know there is supposed to be some issues with IE settings, so I went in to Internet Options > Security > Local Intranet > Sites & unchecked 'automatically detect intranet network' and instead checked a few boxes manually. This has worked in other environments in the past.
Does anybody have a clue why this is happening?
Scott
I'm going to be migrating an application from Access 2002 to Access 2010 in the near future, as we're running into problems with this app on Win7 machines.
First step - get connectivity working.
I've mapped a folder named 'SERVER' on my local machine to W:. Inside this folder sits another db: Custom_Reports.mdb. In my VBA startup module, I'm attempting to connect to this database. When I run this line:
Code:
Set dbCustomReports = DBEngine.Workspaces(0).OpenDatabase(strCustReportsLocation, False, False, "MS Access;PWD=**********")The application crashes, where strCustReportsLocation = 'W:\Custom_Reports.mdb". If I set strCustReportsLocation to C:\Server\Custom_Reports.mdb" instead, it works.
I know there is supposed to be some issues with IE settings, so I went in to Internet Options > Security > Local Intranet > Sites & unchecked 'automatically detect intranet network' and instead checked a few boxes manually. This has worked in other environments in the past.
Does anybody have a clue why this is happening?
Scott
