Hi,
I moved to a SQL backend many years ago, and all has worked well, however, I have been made to feel like an idiot and a total novice, because I know nothing of stored procedures/ triggers / transactions etc.(well I never got any training, so it's been a seat of the pants job working here!)
If stored procedures and transactions will improve my Access apps and user experience then i want to know more.
I have asked in the same forum but just got told to google SQL BOL or stored procedures, which isn't very helpful as I am lookng for specific guidance in a specific environment, I am currently studying a diploma course via the OU and have enough reading material currently to get through when not a work!
I was hoping someone might be able to advise the best way to start replacing some of the queries in MS access with stored procedures and provide examples.
A form is normally bound to a data source via a query, how do i replace that with a stored procedure without breaking the 'bound' fields on the form.
And how much performance benefit will this give over the standard way of binding tables / querries.
all help is very much appreciated.
regards,
1DMF
I moved to a SQL backend many years ago, and all has worked well, however, I have been made to feel like an idiot and a total novice, because I know nothing of stored procedures/ triggers / transactions etc.(well I never got any training, so it's been a seat of the pants job working here!)
If stored procedures and transactions will improve my Access apps and user experience then i want to know more.
I have asked in the same forum but just got told to google SQL BOL or stored procedures, which isn't very helpful as I am lookng for specific guidance in a specific environment, I am currently studying a diploma course via the OU and have enough reading material currently to get through when not a work!
I was hoping someone might be able to advise the best way to start replacing some of the queries in MS access with stored procedures and provide examples.
A form is normally bound to a data source via a query, how do i replace that with a stored procedure without breaking the 'bound' fields on the form.
And how much performance benefit will this give over the standard way of binding tables / querries.
all help is very much appreciated.
regards,
1DMF
Last edited: