Re: FN-FORUM Access to SQL server

date posted 15th January 2003 13:27

you'll need to make some changes if you plan to use sql sever in a function
other than 'access writ large'

for starters inserts and updates should by done via sprocs - for ease of use
as well as performance. if you need to update several tables then you'll
soon see why sprocs are a godsend.

you'll be able to queries (or views as sql server calls them) and really any
SELECTS should be from views rather than tables on order to hide your
schema.

finally after all that check out the structure, ensure the relationships are
sound and the tables are indexed properly.

after going through this a couple of years back any site i do in access now
has all inserts/updates placed in functions so i just have to alter a couple
of include files ti reflect the changes throughout the site - saves loads of
time!

----- Original Message -----
From: "wastedmedia" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Wednesday, January 15, 2003 12:59 PM
Subject: FN-FORUM Access to SQL server


>
> hi people,
>
> I recently built a site for a client using access and asp [through I did
> suggest at the time that this could prove problematic further down the
line]
> the client now want to upgrade the database to SQL Server.
>
> Having never done this before I found a few tech tips etc for exporting
the
> data, but am wondering if any one can give me any pointers on the
following:
>
> a] will I need to make changes to general SQL code that is employed in the
> pages, such as select, insert, update etc?
>
> &
>
> b] I have used queries in a number of cases in the access database - can I
> still use these in SQL Server?
>
> any help or pointers much appreciated,
>
> cheers
>
> Tim
>
>
> ========
> Advertise with Freelancers.net +Additions+
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]