Excel 2010 VB problem after server move
Posted on 2012-09-10
Our users had some excel spread sheets that had a field pointing towards a database on a server that was recently retired (of course we had no idea this even existed) and I'm trying to point it towards the location of the new server, I've verified that the file is there in the path specified but the field is still failing when someone tries to type any info in it. When I run the debugger this is what shows up:
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.ConnectionString = "Data Source=\\Cargo-fs-02\Public\ProdData\ProdData.mdb"
It's saying that failure is at the cn.Open command. What step am I missing here?