If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.???

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!

"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

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
>

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.

"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
> >
>

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

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