Access or SQL??


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Access or SQL??

Hybrid View

  1. #1
    Josh Guest

    Access or SQL??


    Ok,
    Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion of
    .asp . I have a database that I have been working with that is done in Access
    2000. I have been told in order for this site to work it will have to be
    imported into an SQL Database instead of Access on a SQL Server at my ISP.
    So this means that I cant use Access for small dynamic sites and that ISP's
    dont support Access.. and I will have to buy SQL 7.0 for my design shop???
    Im sooo stressed out now.. Just when I thought I could make money I have
    to buy more software.. I hope not..
    But in order for by sites to work they must be imported to SQL right or wrong.???

    Thanks.

    Josh

  2. #2
    Don Wolthuis Guest

    Re: Access or SQL??


    How's it going Josh?

    Who was it how told you that you HAVE to use SQL? They are wrong or lying!
    You don't have to, but I would if I were you! It is worth the investment
    and the more you get into developing the more you will realize that! You
    will find many limitations in Access that don't exsist in SQL, and SQL is
    much more powerful! In summary, if I were you I would use SQL, but you don't
    have to!

    Good luck!
    ___________________
    Don Wolthuis
    MCSD
    CodeJunkies.net
    comming soon......
    ASPNextGen.com
    theFutureofASP.com


    "Josh" <rwmgraphics@aol.com> wrote:
    >
    >Ok,
    >Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion of
    >.asp . I have a database that I have been working with that is done in Access
    >2000. I have been told in order for this site to work it will have to be
    >imported into an SQL Database instead of Access on a SQL Server at my ISP.
    >So this means that I cant use Access for small dynamic sites and that ISP's
    >dont support Access.. and I will have to buy SQL 7.0 for my design shop???
    > Im sooo stressed out now.. Just when I thought I could make money I have
    >to buy more software.. I hope not..
    >But in order for by sites to work they must be imported to SQL right or

    wrong.???
    >
    >Thanks.
    >
    >Josh



  3. #3
    ed Guest

    Re: Access or SQL??


    I was at a conference recently and during a presentation Bill Vaughn (from
    Microsoft) mentioned that if more than 25 users attempt to open an Access
    database at the same time you'll have problems. I had experienced this previously
    when using Access over a LAN. I always attributed the problem to me doing
    something wrong but after Bill made that comment it made sense. Access is
    geared towards single users or small groups of users - it's not a robust
    business solution.

    You could try testing your site with a load-balancing tool to simulate more
    than 25 users and see if you run into problems, but I guess that depends
    on your development environment.

    >"Josh" <rwmgraphics@aol.com> wrote:
    >>
    >>Ok,
    >>Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion

    of
    >>.asp . I have a database that I have been working with that is done in

    Acces
    >>2000. I have been told in order for this site to work it will have to be
    >>imported into an SQL Database instead of Access on a SQL Server at my ISP.
    >>So this means that I cant use Access for small dynamic sites and that ISP's
    >>dont support Access.. and I will have to buy SQL 7.0 for my design shop???
    >> Im sooo stressed out now.. Just when I thought I could make money I

    have
    >>to buy more software.. I hope not..
    >>But in order for by sites to work they must be imported to SQL right or

    >wrong.???
    >>
    >>Thanks.
    >>
    >>Josh

    >



  4. #4
    Michael \(michka\) Kaplan Guest

    Re: Access or SQL??

    Since scalable components are STATELESS by their very nature, a good
    e-commerce site will never have too many simultaneous connections. Unless
    you truly believe you will be busier than Amazon or somesuch, Jet will
    actually do the job in more cases than you realize.

    --
    MichKa

    random junk of dubious value at the multilingual
    http://www.trigeminal.com/ and a new book on
    i18N in VB at http://www.trigeminal.com/michka.asp

    "ed" <esullivan@cross.com> wrote in message news:397c48df$1@news.devx.com...
    >
    > I was at a conference recently and during a presentation Bill Vaughn (from
    > Microsoft) mentioned that if more than 25 users attempt to open an Access
    > database at the same time you'll have problems. I had experienced this

    previously
    > when using Access over a LAN. I always attributed the problem to me doing
    > something wrong but after Bill made that comment it made sense. Access is
    > geared towards single users or small groups of users - it's not a robust
    > business solution.
    >
    > You could try testing your site with a load-balancing tool to simulate

    more
    > than 25 users and see if you run into problems, but I guess that depends
    > on your development environment.
    >
    > >"Josh" <rwmgraphics@aol.com> wrote:
    > >>
    > >>Ok,
    > >>Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion

    > of
    > >>.asp . I have a database that I have been working with that is done in

    > Acces
    > >>2000. I have been told in order for this site to work it will have to be
    > >>imported into an SQL Database instead of Access on a SQL Server at my

    ISP.
    > >>So this means that I cant use Access for small dynamic sites and that

    ISP's
    > >>dont support Access.. and I will have to buy SQL 7.0 for my design

    shop???
    > >> Im sooo stressed out now.. Just when I thought I could make money I

    > have
    > >>to buy more software.. I hope not..
    > >>But in order for by sites to work they must be imported to SQL right or

    > >wrong.???
    > >>
    > >>Thanks.
    > >>
    > >>Josh

    > >

    >




  5. #5
    just_me Guest

    Re: Access or SQL??

    If you have the ability to go with SQL at your ISP then do it while keeping
    Access on your design server. You can create aps with code that will work
    just fine on either but you will be missing the full power of SQL Server.
    All you have to do is have 2 file DSNs, and check your HTTP server headers
    at the time you make your connection, and if the server is yours, use the
    Access DSN, otherwise, use the DSN that will work for your ISP,

    There are also freeware solutions to your problem such as MySQL if your ISP
    will support it.


    Josh <rwmgraphics@aol.com> wrote in message news:397930bd$1@news.devx.com...
    >
    > Ok,
    > Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion of
    > asp . I have a database that I have been working with that is done in

    Access
    > 2000. I have been told in order for this site to work it will have to be
    > imported into an SQL Database instead of Access on a SQL Server at my ISP.
    > So this means that I cant use Access for small dynamic sites and that

    ISP's
    > dont support Access.. and I will have to buy SQL 7.0 for my design

    shop???
    > Im sooo stressed out now.. Just when I thought I could make money I

    have
    > to buy more software.. I hope not..
    > But in order for by sites to work they must be imported to SQL right or

    wrong.???
    >
    > Thanks.
    >
    > Josh




  6. #6
    Andrea Williams Guest

    Re: Access or SQL??

    If someone told you that you HAVE to use SQL Server, I would like to know
    more of the circumstances before I make an assessment about that. But by
    saying that, they are probably doing you a favor. As far as ISP's not
    supporting Access, some do, (though I often wish they didn't).

    We have insisted that some of our customers upgrade and use SQL Server
    instead of Access. In my experience, Access is more difficult to work with
    when you want to change the database structure. You basically have to shut
    down the web site to make any changes. This could potentially be a lot of
    down time.

    With SQL Server the database structure can be changed using a SQL script.
    (I suggest you test your script BEFORE you run it on the live database
    though!) I'm not an Access guru, but I've not yet found a good easy way to
    update the database structure in Access. (I end up swearing a lot every
    time I have to deal with it.)

    In short, Access is supported by some ISP's, but in the long run, you'd be
    better off using SQL Server which is a lot more rebust and doesn't have near
    as many issues when working with it and using it.

    Thanks,

    --
    Andrea W



    Josh <rwmgraphics@aol.com> wrote in message news:397930bd$1@news.devx.com...
    >
    > Ok,
    > Im using Macromedia UltraDev to create E-commerce Sites w/ cold fusion of
    > asp . I have a database that I have been working with that is done in

    Access
    > 2000. I have been told in order for this site to work it will have to be
    > imported into an SQL Database instead of Access on a SQL Server at my ISP.
    > So this means that I cant use Access for small dynamic sites and that

    ISP's
    > dont support Access.. and I will have to buy SQL 7.0 for my design

    shop???
    > Im sooo stressed out now.. Just when I thought I could make money I

    have
    > to buy more software.. I hope not..
    > But in order for by sites to work they must be imported to SQL right or

    wrong.???
    >
    > Thanks.
    >
    > Josh




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center