locked
how open .Dat file in MS Access RRS feed

  • Question

  • User250444435 posted

    Hello All,

    I wan to edit Database file which is with .dat Extension.

    The Connection string use in Configuration file that is.

    <add name="TecsHomeConnectionString"
                connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TecsHome.dat; Jet OLEDB:Database Password=fdsa"
                providerName="System.Data.OleDb" />

    I have TecsHome.dat file. I am opening it in MS Access using Passwored = fdsa but MS access prompting invalid Password

    how can i open it if the given password in connectionstring is not working.


    keep in mind i don't have source code. I just want to open .Dat Database file.

    Thursday, October 7, 2010 6:30 AM

Answers

  • User275991403 posted

    Hi,


    dat file only supports random access reading.And it doesn't open in msaccess or anyother software.Better way you write a code in VBA to export data from dat file to msaccess.


    Use this link:

    http://www.tek-tips.com/viewthread.cfm?qid=117248&page=1502


    it   will help you.


    Regards,

    Saravanan.P

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 11, 2010 10:21 AM