Results 1 to 10 of 10
  1. #1
    vanthien is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2013
    Posts
    21

    Access 2003 >> how to obtain source code

    Hi,


    Back in the 90's I developed a fairly complex Access 2003 database, now on a corporate network, and the IT folks are now requiring me to use a "subversion repository" for version control,
    i.e. I need to upload the "source code" for this database.

    A little side note: I never used Developer software for this. The entire database, objects, VBA code, was developed in MS Access.

    How can I access/create the "Source Code" for this database?

    Thanks,
    Frank :-)

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    just upload the database. It has all the source code in it, along with forms. Put a 'version' number in the name.
    I use the date

    myDatabase-161009.1800.accde

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I'm pretty sure that it's the queries, forms, vba etc that is the "source code" for Access.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    There's also SaveAsText/LoadFromText if they don't want the actual objects.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    vanthien is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2013
    Posts
    21
    My file extensions are .mdb, not .accde.
    I don't see any menu options to SaveAsText/LoadFromText. Note that I use full version Access 2003, NOT Access Developers software.
    I'll ask for some more clarification, but it looks like they want all code in text files!

  6. #6
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    you can use the database documenter to create the reports then export to a text file. You can use a later version of access to open a mdb, you'll find it on the ribbon under database tools, can't remember where it is in 2003 but should not be difficult to find.

    SaveAsText/LoadFromText are undocumented vba subs. If you go into the vba window, and in a new module/sub type saveastext you will be prompted for object type, object name and the file path and name for the text file.

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    "SaveAsText/LoadFromText" are undocumented commands.

    I haven't used this, but see:
    http://www.access-programmers.co.uk/...d.php?t=173624

    I have used by this code by Arvin Meyer to document a database:
    http://www.accessmvp.com/arvin/ (top of the page)



    Also, I searched on "access saveastext". These might be of interest.

    https://msdn.microsoft.com/en-us/lib...ice.11%29.aspx

    http://www.allenbrowne.com/ser-47.html (at the bottom of the page)http://stackoverflow.com/questions/4...red-procedures

  8. #8
    vanthien is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2013
    Posts
    21
    Wow, thanks for all the tips! I'm experiencing some unrelated glitches, but I will get to this soon.

  9. #9
    vanthien is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2013
    Posts
    21

    db documenter

    Quote Originally Posted by ssanfu View Post
    "I have used by this code by Arvin Meyer to document a database:
    http://www.accessmvp.com/arvin/ (top of the page)

    That's a beauty and worked like a charm.Thanks very much.
    It's still not quite clear to me what if anything I need to do about documenting the tables, but at least all the other objects are now documented.
    Thanks!

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If you have provided a description for your tables and the fields within the tables, then that information should be included in any documentation.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-31-2016, 05:18 PM
  2. VBA code in Access 2003
    By coolpal9 in forum Access
    Replies: 3
    Last Post: 01-03-2012, 11:30 PM
  3. Get a websites source code with access
    By trb5016 in forum Programming
    Replies: 1
    Last Post: 01-08-2010, 03:23 PM
  4. Access 2003 code vs Access 2007 Code
    By ralphjramirez in forum Access
    Replies: 5
    Last Post: 11-23-2009, 12:33 PM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums