Forum Discussion

jackson_1's avatar
jackson_1
Frequent Contributor
15 years ago

can not connect to MS access 2010

hi all,



 i meet a strange error when i connect to MS access 2010 database. the error notice that 

" W:\test.accdb  is not a valid path.make sure that the path name is spelled correctly and that you are connected to server on which the fiels resides", i am sure that the database file exist in this path , 

and my tc is 7.52., my OS is windows 7 32 bits. but  it works well when in windows 7 64 bits.

when i use access 2007 it works well, but when i updated my office to 2010 this error occured. any suggestions for me?

i used connection strings: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= w:\test.accdb"



thanks deeply!

2 Replies

  • AlexeyKolosov's avatar
    AlexeyKolosov
    Icon for Staff rankStaff
    15 years ago
    Hi Jackson,



    First of all, I'd like to note that the error is returned by your data provider and therefore most probably it is not related to TestComplete. As I understand, the connection string works for Access 2007, but does not work for Access 2010. If so, you probably need to use another provider and/or connection string for Access 2010. For example, you can find more information on this here:


    http://www.vbdotnetforums.com/odbc/45688-connecting-access-2010-database.html



    Also, try moving the file to a local folder (I suppose that w:\ is a mapped drive) - there is a small chance this will help.
  • jackson_1's avatar
    jackson_1
    Frequent Contributor
    15 years ago
    thanks allen.



    this problem solved that because my access file path not correct.



    Thanks again.