How To Create Mdb File

creating mdb file

• Question

• How do i create a mdb file when i have modules in databse

All replies

• create mdb file and import modules

  ---

  Michał

• Good Morning Seed Enterprises,

  If you are using Access 2013 in order to make an .mdb file goto; File Option \ General \ Creating Databases \ Default file format for blank database = 2002 - 2003 and New Database sort order, General Legacy. You may also need to change; File Options \ Client Settings \ Advanced \ Encryption Method = Use Legacy Encryption (good for reverse compatibility and Multi-User databases).

  Hth

  ---

  Just takes a click to give thanks for a helpful post or answer.
  Please vote "Helpful" or Mark as "Answer" as appropriate.
  Chris Ward
  Microsoft Community Contributor 2012
  

• >>How do i create a mdb file when i have modules in databse<<

  ???

  If you referred to Access VBA Modules then where do your store these Modules WITHOUT an Access database file (MDB or ACCDB file extension)?

  If you are new to Microsoft Access, you may need to read an introductory book, at least the first few chapters so that you can phrase your questions to be meaningful to potential respondents so that they can help you...

  ---

  Van Dinh

• i have noticed i cannot  create a mdb file when i have modules in my database. then is it possible to reverse the action ie from mdb to accde or accdb
  

• >>
  i have noticed i cannot  create a mdb file when i have modules in my database .
  <<

  ???

  What kind of file is the database you mentioned in "my database"?  What is the file extension of the file?

  Please explain why you need to create a (new) database file with file extension MDB while you are currently working with your existing database?

  >>
  is it possible to reverse the action ie from mdb to accde or accdb
  <<

  MDB is the old file format and ACCDB is new file format that only works with Access 2007 and later.  Thus, if you want to convert an existing MDB file to an ACCDB file, it is not a reverse action.  If you use Access 2007 and later, there in a command to do the conversion of an existing MDB to ACCDB format in the Ribbon or Office Button.

  ---

  Van Dinh

  
  

  • Edited by Thursday, December 4, 2014 11:27 PM Typos

• Your question makes no sense. Modules are automatically included when you create a database. So lets start over:

  1. What version of Access are you using?
  2. Describe what steps you are going through to create the .mdb file?

• How do i create a mdb file when i have modules in databse

  Hi seed enterprise,

  I think you mean this:

  Can I run an A2007 database using A2003? Answer is: No

  Can I run an A2003 database using A2007? Answer is: Yes

  In general upwards compatibility Yes, downwards compatibility No.

  A97 databases should first be converted to A2000/A2003 file format.

  Imb.

How To Create Mdb File

Source: https://social.msdn.microsoft.com/Forums/office/en-US/b6f16eef-8d2c-423f-8c96-9d608bfc8403/creating-mdb-file?forum=accessdev

Posted by: stevensonnotheires.blogspot.com

Share this post