Thread: MS Access Databases 2003

  1. #1
    essence of digital xddxogm3's Avatar
    Join Date
    Sep 2003
    Posts
    589

    MS Access Databases 2003

    I created a database for my work and was wondering about one issue.
    forms, queries, switchboard, etc.
    how can i make it a stand alone?
    where you can click on the file and it opens, with out access opening. i understand that it needs access to function, but the people that will be using this are (forgive me for saying it) very technology ignorant (more then me ). i want to make it as easy as possible.
    i want the file to open directly to the switchboard, w/o anything to add to the confusion.
    "Hence to fight and conquer in all your battles is not supreme excellence;
    supreme excellence consists in breaking the enemy's resistance without fighting."
    Art of War Sun Tzu

  2. #2
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,079
    You can't. Access' .db files are designed to open only in access. You can do various write protection and locking to the database to prevent people from doing anything but what you want them to do, though.
    Sent from my iPadŽ

  3. #3
    essence of digital xddxogm3's Avatar
    Join Date
    Sep 2003
    Posts
    589
    is there a way to have it were you click on the file, and it goes directly to the switchboard?
    "Hence to fight and conquer in all your battles is not supreme excellence;
    supreme excellence consists in breaking the enemy's resistance without fighting."
    Art of War Sun Tzu

  4. #4
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    By "switchboard", I assume you mean some sort of menu. And yes, you can use the autoexec command in Access to open a form when Access opens the file.

    But keep in mind that anyone that has the developer tools installed can blow right by that by closing the form (not that it seems that would be the case).

    I'm also hoping that you would have an alternative. Using Access for multiple users is a really bad idea.
    EntropySink. You know you have to click it.

  5. #5
    Registered /usr
    Join Date
    Aug 2001
    Location
    Newport, South Wales, UK
    Posts
    1,273
    Life would probably be sunnier with a gentle north-easterly breeze if you made the forms and whatever other interfacy things you have in a programming language and ADO in to your .MDB. Visual Basic is the fastest for that sort of thing bar none.

  6. #6
    Yes, my avatar is stolen anonytmouse's Avatar
    Join Date
    Dec 2002
    Posts
    2,544

  7. #7
    essence of digital xddxogm3's Avatar
    Join Date
    Sep 2003
    Posts
    589
    Life would probably be sunnier with a gentle north-easterly breeze if you made the forms and whatever other interfacy things you have in a programming language and ADO in to your .MDB. Visual Basic is the fastest for that sort of thing bar none.
    how would i do this?
    can i do this with the visual basic editor that is included with access? or would i need the stand alone vb editor with ms studio?

    >> how can i make it a stand alone? <<

    Deploying Microsoft Access Applications using the Access Runtime
    This is interesting, but i'm unable to find the packaging wizard on my access or the run times.

    By "switchboard", I assume you mean some sort of menu. And yes, you can use the autoexec command in Access to open a form when Access opens the file.
    thanks that helped.
    "Hence to fight and conquer in all your battles is not supreme excellence;
    supreme excellence consists in breaking the enemy's resistance without fighting."
    Art of War Sun Tzu

  8. #8
    Registered /usr
    Join Date
    Aug 2001
    Location
    Newport, South Wales, UK
    Posts
    1,273
    Quote Originally Posted by xddxogm3
    how would i do this?
    can i do this with the visual basic editor that is included with access? or would i need the stand alone vb editor with ms studio?
    I'm talking about stand-alone VB, yes. I dunno what VB.NET is like with Access databases, but I know VB6 has plenty of controls (combo boxes, grids, etc.) that can be bound to a data source with the minimum of fuss. That would get you an .EXE as well as your .MDB. (Oh, and the VB runtime DLL as well if they don't have it)

    As for one file that does it all, then Access runtime is probably the way to go.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Error connecting from Dev C++ to MS Access Database
    By Sridar in forum C++ Programming
    Replies: 0
    Last Post: 04-15-2006, 06:09 PM
  2. Ping
    By ZakkWylde969 in forum Tech Board
    Replies: 5
    Last Post: 09-23-2003, 12:28 PM
  3. Connect 2 domains together (with Windows 2003 and Exchange 2003)?!?!??
    By gicio in forum Networking/Device Communication
    Replies: 2
    Last Post: 09-01-2003, 07:02 PM
  4. Question on MS Access
    By 041785h in forum A Brief History of Cprogramming.com
    Replies: 0
    Last Post: 10-08-2001, 09:18 AM
  5. Question on MS Access
    By 041785h in forum A Brief History of Cprogramming.com
    Replies: 0
    Last Post: 10-06-2001, 11:22 AM