Moving to SQL from Access

[Gubbins]

Hi i have recently upgraded my hosting package and this includes SQL and so
from now i wish to make available SQL to clients. I am looking for general
advice like: How do you get over the non autonumber access provided for your
primary keys? Is there anything major you need to consider when using SQL over
Access? Is it easy to upgrade from Access to SQL? And any thing else that i
might need to think about? Thanks in advance Gubs

[CMBergin]

"Gubbins" <webforumsuser@macromedia.com> wrote in message
news:cvnjtv$i0$1@forums.macromedia.com...

> Hi i have recently upgraded my hosting package and this includes SQL and

so

> from now i wish to make available SQL to clients. I am looking for general
> advice like:

How do you get over the non autonumber access provided for your

> primary keys?

You can define your primary key to be anything which makes sense. If you
want a surrogate key as your primary key like Access does, just set up an
Identity column with the seed and increment both set to 1.

Is there anything major you need to consider when using SQL over

> Access?

Your interaction with the database will be very different. You don't
"upload" a SQL Server database, so developing locally and then moving to the
live server is a bit more involved. Also, to develop locally, you'll need
to download the MSDE from Microsoft.

Is it easy to upgrade from Access to SQL?

Yes. There are wizards to make it relatively painless.

And any thing else that i

> might need to think about?

You may need to alter some of your queries, but mainly you'll be learning
about all sorts of new abilities you have. If you're not comfortable in
Enterprise Manager and Query Analyzer, you can visit [url]www.charon.co.uk[/url] for a
tutorial on how to connect to SQL Server via the Access interface.

Thanks in advance Gubs

>

[Webconsul470]

Use Microsoft Access Projects.
It is great.

SoCal

[Gubbins]

thanks for that chaps! i was thinking about using a unique id in the form say AAAA1234 how would i increment that?

thanks

Gubs

[Paul Whitham TMM]

You would have to build something like that in the form

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Gubbins" <webforumsuser@macromedia.com> wrote in message
news:cvo8pi$t86$1@forums.macromedia.com...

> thanks for that chaps! i was thinking about using a unique id in the form

say AAAA1234 how would i increment that?

>
> thanks
>
> Gubs