Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6

Thread: MS Access

  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Access

    Dumb question? Don't hit me

    in order to have an MS Access db and upload it to my server - do I have to have MS Access program??

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not going to hit you, just asking to clarify.

    To create an access-db, you indeed need to have MsAccess. But to simply upload it (like if you create the acces-db on computer1, then put it one a cd and iupload it from computer 2 to computer 3, then you need MsAccess on computer 1 and computer3.

    If this doesn't answer your question, then please clarify.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    Regular Coder
    Join Date
    Jul 2002
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts
    that was perfect.

    Basically I needed to know if I needed Access in order to create the invoice - which you answered - yes.

    Thank you

  • #4
    Regular Coder
    Join Date
    Oct 2004
    Location
    In front of this computer. (Where else?)
    Posts
    442
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm going to hit you! Do i need bread to create a sandwich? Course I do!
    Do i need access to create an mdb database? now you answer that
    Tomorrow is the first day of the rest of your life... What have you done today?
    Tutorials
    Web: w3schools, htmldog General tips: Hardware, Networking

  • #5
    New to the CF scene
    Join Date
    Nov 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Actually, if you have MDAC (MS data access components) installed on your PC you can use a programming language (such as VB.NET, C# etc) to create and manipulate an Access database without having Access installed.

  • #6
    Regular Coder
    Join Date
    Oct 2002
    Posts
    380
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There seems to be a general confusion about what Access is. probably about what a database is, as well. A database consists of a bunch of files which are created by sending commands to database engine. It may also have a front end that makes it easier to send the commands and view the results of these commands. These are commonly thought of collectively as "the database" but they're at least conceptually independant, if not functionally. It's not dissimilar to how your PC runs: application software on an operating system on hardware. You tell you application what to do; it tells your OS; your OS tells your hardware.

    Access basically a front end. It has a bunch of tools and so forth built into it, but it is not really a database. It's not even a database engine (it uses the JET database engine, as I recall). You use Access to create a database - which it does by sending commands to the database engine which processes them and (if necessary) records them in the MDB file. There are other tools that can be used to access the MDB files; Access is merely the simplest and most convienient. Similarly, Access can be used to manipulate other database engines (eg it can be used as a front-end for SQL Server).

    For the record, MYSQL is primarily a database engine.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •