• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Excel 2010 VB problem after server move

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"
cn.Open

It's saying that failure is at the cn.Open command.  What step am I missing here?
0
adml_shake
Asked:
adml_shake
1 Solution
 
RyanProject Engineer, ElectricalCommented:
default user and pw?

cn.ConnectionString = "Data Source=\\Cargo-fs-02\Public\ProdData\ProdData.mdb;Provider=Microsoft.Jet.OLEDB.4.0;User Id=admin;Password=;"

reference
http://www.connectionstrings.com/access
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now