I have a web application that links to Microsoft Access and opens one of five databases depending on which button is clicked. The purpose of the web app is to open an instance of the database for an employee to use the forms that we've coded in the database itself.
I coded it on my machine in Visual Web Developer 2008 and it works exactly as expected when ran on my machine, but when I move the files to a laptop that I need to use to present the web application to the people that need to approve them it stops working. This laptop also has Visual Studio 2008 and I'm able to open and run the web app just fine, but I get the following error when any of the five buttons are clicked:
"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
A very shortened snippet of the VB code is below. The last line is where the error is thrown. The databases are all on internal network drives and I can open them manually on the laptop by navigating through the folders, so it's not that they aren't there or that they actually are corrupt. Any ideas?
Dim db As Access.Application
db = New Access.Application
db.OpenCurrentDatabase("Path As String Here")