Windows 10: Changing file format in access from .mdb to .accdb

Discus and support Changing file format in access from .mdb to .accdb in Microsoft Office and 365 to solve the problem; Hello office users, I have an access database created in MS Access 2003. My PC has Office 365 with Access installed now. I am able to view the .mdb... Discussion in 'Microsoft Office and 365' started by bcloonan, Nov 12, 2018.

  1. bcloonan Win User

    Changing file format in access from .mdb to .accdb


    Hello office users,

    I have an access database created in MS Access 2003. My PC has Office 365 with Access installed now. I am able to view the .mdb file format however, I want to convert to the .accdb file format. I followed instructions on how to do this through an MS article. I found that i needed to decode the data. I was successful in doing this. The file shows up in the file directory with the .accdb file format. However when I attempt to open the file i receive a flash message telling me the file is in use. It is not. Any ideas out there? The database was created around 2005 by another individual who longer lives in the area. *Sad*Confused

    :)
     
    bcloonan, Nov 12, 2018
    #1

  2. Microsoft Access Database (.mdb) file

    Thank you, Andrze for information pertaining to "Convert a database to the .accdb file format"
     
    CharInCincy, Nov 12, 2018
    #2
  3. Microsoft Access Database (.mdb) file

    Hi Andrze,

    If you're running Microsoft Access 2007 or newer (2010, 2013, or 2016), then the best way to convert an MDB file is to first open it and then save the open file to another format.

    Just click the link below

    Convert a database to the .accdb file format

    hope this helps.
     
    Nathaniel_M, Nov 12, 2018
    #3
  4. Changing file format in access from .mdb to .accdb

    User accounts in VB2005 from MS Access

    I wasn't suggesting moving the result of the replace back to the textbox.

    More like Dim sqlString As String = "INSERT INTO USERS ([USERNAME], [PASSWORD]) VALUES ('" & replace(textbox1.text, "'", "''") & "', '" & replace(textbox2.text, "'", "''") & "')".

    And I think the whole issue was the closing bracket I forgot *Smile Changing file format in access from .mdb to .accdb :) At least with Accdb (2007) files you don't have to use those [Access brackets] when accessing data from .NET. Not sure if that's forced with mdb files though.
     
    DanTheBanjoman, Nov 12, 2018
    #4
Thema:

Changing file format in access from .mdb to .accdb

Loading...
  1. Changing file format in access from .mdb to .accdb - Similar Threads - Changing file format

  2. Download format files. How to change?

    in Windows 10 Ask Insider
    Download format files. How to change?: So i am trying to get a file downloaded but it keeps downloading as a Photoshop file. how do i change the default way that it downloads to like a pdf or a jpg. submitted by /u/dovice_YT [link] [comments]...
  3. changing a file format

    in Windows 10 Network and Sharing
    changing a file format: I am trying to change an email file into a different file format so I am able to upload it to a company https://answers.microsoft.com/en-us/windows/forum/all/changing-a-file-format/54867f08-bcaa-419b-aada-2c6b5e3a26d7"
  4. Windows file format changed to .mmnn

    in AntiVirus, Firewalls and System Security
    Windows file format changed to .mmnn: Hi, I am facing a big problem. I'm using windows 10. All my files has been changed to .mmnn format. Ex: my_cv.docx changed to my_cv.docx.mmnn. How to solve this problem. Please help me....
  5. how can i open an Access file (mdb) as an administrator?

    in Windows 10 Network and Sharing
    how can i open an Access file (mdb) as an administrator?: how can i open an Access file (mdb) as an administrator? https://answers.microsoft.com/en-us/windows/forum/all/how-can-i-open-an-access-file-mdb-as-an/bd77bf69-2c0b-461d-8052-1e79eb4c7b5d"
  6. MDB Shortcut Opens In Another Access Taskbar Icon

    in Windows 10 Customization
    MDB Shortcut Opens In Another Access Taskbar Icon: Hi, I previously was using Microsoft Office 2016 standalone. I had created a shortcut for "C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE" D:\MediaDB\MoviesMusic.accdb and pinned it to my taskbar. When I clicked on it, MDB file would open using the same...
  7. converting Access .mdb back-end to MySQL?

    in Windows 10 Customization
    converting Access .mdb back-end to MySQL?: I'm investigating converting my Access program back-end to MySQL and am looking for information about what would be involved and what, if any, changes it would require on the front-end. I'd appreciate just references to respected information sources. Gordon...
  8. File Format Change

    in Windows 10 Software and Apps
    File Format Change: Hi, My all File format suddenly change with "Assignments1.xlsx.DATAWAIT" DATAWAIT Format, how I can resolve this issue. Thanks https://answers.microsoft.com/en-us/windows/forum/all/file-format-change/5837546c-3714-4139-9b55-7b5c565aea1d
  9. urget!!!!!!!!Files format change

    in Windows 10 Network and Sharing
    urget!!!!!!!!Files format change: hi guys, all of sudden my personal files (pictures, word....) had their names to garbage (exp: xghjgsfsvs.94da) instead of their normal format. the size of files is still the same but I can not open any of them....my windows is 10 updated and clean system and my antivirus...
  10. changing file format

    in Windows 10 Software and Apps
    changing file format: how do you change txt file to pdf? https://answers.microsoft.com/en-us/windows/forum/apps_windows_10-winapps-appscat_tools/changing-file-format/fb57ff45-456a-4307-bb4e-1e8d1c1eb605