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. Change default save as file format

    in Windows 10 Network and Sharing
    Change default save as file format: Hi Normally my laptop default save as file is jpeg. Recently I downloaded tiff file to my laptop. And now my default save as file change to tiff format. Please help how to change back to jpeg format....
  3. 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...
  4. 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...
  5. KB4480116 and KB4480970 failure getting access to MDB database ( Access 97 )

    in Windows 10 Installation and Upgrade
    KB4480116 and KB4480970 failure getting access to MDB database ( Access 97 ): After installing in Windows 10 the KB4480116, our application ( developed in VS2010 with Microsoft Access 97 database MDB ) detects an error "unknown database format" when accessing to Access 97 database. The exception starts on msvc100.dll provided by VS 2010. Removing the...
  6. Cant change default file format

    in Windows 10 Network and Sharing
    Cant change default file format: Hello! Once i stopped program called "File oppener" or something like that, thru task manager. Ever since i cant change default file applications. On this image i went on file, clicked properties, change file something, idk how is it in english, but you understand it, right?...
  7. 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
  8. 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...
  9. 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
  10. recovering files from a formatted drive

    in Windows 10 Support
    recovering files from a formatted drive: What is the best and cheapest software to recover files from a formatted usb hard drive (WD Elements) 89011