Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Programming with MS Access

  • 08-10-2004 12:52pm
    #1
    CuriosityKilled
    Closed Accounts Posts: 4 ✭


    Background: I'm currently working with a piece of Stock Control software and for some reason I've a desire to write a little program that would recreate some of its basic functions just to get a better understanding of what is happening in the background. In the past I did know a bit of C and Java but haven't used the skills in a couple of years.

    I intend on designing a database and want a front end to allow user interaction. I know I could just use the forms etc in Access itself but I'm looking for a challenge and to get back and relearn some of the programming skills I once had.
    What programming language would people recommend using to interact with Access databases. Speed would be key as the sql queries would be on very large product tables.

    I could be showing huge naivety in thinking I have the knowledge or skills to attempt this so any pointers in the right direction would be much appreciated.


Comments

  • #2
    bonkey
    Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭bonkey


    CuriosityKilled wrote:
    What programming language would people recommend using to interact with Access databases. Speed would be key as the sql queries would be on very large product tables.

    At the risk of pointing out the obvious....

    Whatever language you write the app in will have absolutely no effect on how fast your SQL queries run against the database....even for a file-based DB like Access. They may determine how fast the returned results can be visualised, but thats a seperate issue.

    What will impact your performance is how well you've designed your DB (e.g. table indexes etc.), and how well you've written your queries (if they're non-trivial).

    Oh - and I'd be curious to know what you consider "very large". For me, thats into the hundreds of thousands of rows...and - TBH - while Access can handle that size, its not in any way optimal. I'd suggest that you have a look at using something like MSSQL Desktop Edition (aka MSDE) instead...or one of the other free DBs like MySQL etc. Hey, if you want real fun (and want to stick the MS tech) then download the beta of SQL Server 2005 Express Edition, and use that as your back end.

    As for a language recommendation....you're right in not wanting to use Access Forms. Stay the hell away from them...they're the work of the devil, as is AccessBasic.

    Personally, with C and Java background....I'd recommend you go check out C#. And shur...why not pull down the Visual C# 2005 Express Edition Beta for that.

    I mean....if you're gonna play with MS tech, why not get ahead of the game instead of playing catchup while you learn ;)

    jc


  • #3
    CuriosityKilled
    Closed Accounts Posts: 4 ✭CuriosityKilled


    Cheers bonkey, confirmed my naivety but also given me enough pointers to go get my feet wet and give it a go and see can I get back into programming etc. Really appreciate your time.

    As for database size in real life the largest table I deal with has almost 2 million records but for this messing around I only intend on using small tables starting off. If I get cocky later I can create large tables to see how well I've done designing my own database,

    Thanks again.


Advertisement