Access less front end

[AnthonyGerrard]

I need to move away from an access front end on at least part of a db. And so make it more lightweight / portable.

Should I be rewriting my data edits/ deletes / inserts as separate stored procedures - as a first step.

At the moment lots of this is handled by bound forms?

Ta

 

[Galaxiom]

Ultimately yes but I wouldn't convert it to procedures until I had a rudimentary front end connected to get a feel for what it is like connecting to the database and how to construct code for the environment.

As your understanding of the front end data needs develop you will be able to write more versatile procedures. Attention to the details of the data interface can make a substantial difference to the complexity and cost of developing the front end.

As you write procedures try to think in these terms and remember to structure your procedure code. SQL in a database server is a programming language in its own right far beyond Access SQL. Judiciously built functions with optional arguments can really simplify coding at every level.

Are you looking an application or a web based solution for the front end?

What kind of environment is typical of your user base? For web solutions, PHP is supported on more server platforms but if your clients are on a Windows domain you might go with ASP.

 

[AnthonyGerrard]

Ultimately yes but I wouldn't convert it to procedures until I had a rudimentary front end connected to get a feel for what it is like connecting to the database and how to construct code for the environment.

As your understanding of the front end data needs develop you will be able to write more versatile procedures. Attention to the details of the data interface can make a substantial difference to the complexity and cost of developing the front end.

As you write procedures try to think in these terms and remember to structure your procedure code. SQL in a database server is a programming language in its own right far beyond Access SQL. Judiciously built functions with optional arguments can really simplify coding at every level.

Are you looking an application or a web based solution for the front end?

What kind of environment is typical of your user base? For web solutions, PHP is supported on more server platforms but if your clients are on a Windows domain you might go with ASP.

I can write reasonable code in TSQL, I do a fair bit in sql itself already. I was hoping to make a start, on creating code to handle the data read/writes.

So all my validation, inserts, edits etc are done on sql, and only messages are returned to the FE in terms of say its a duplicate, etc etc.

To being with I was probably just going to try very simple ID, TExt type lookup table data manipulation. (edits/inserts/deletes)

What will my front end look like eventually - I think probably php.

Have you got any links of how a php may interact with sql? Ta

 

[Rx_]

https://technet.microsoft.com/en-US/library/Cc793139(v=SQL.90).aspx;
This article was written for an older 2005 version of SQL for connection to PHP.
The ratings show that the majority of readers found it useful.
Of interest is a Sample SQL Server DB & PHP to download. The 2005 article sample link points to a SQL Server 2008 sample.
https://msdn.microsoft.com/en-us/library/cc296196.aspx
PHP using Adventure Works on SQL Server 2008

If by chance you download the sample please provide some feedback.
I have not been at all impressed with the Access Web parts. I have been to a full day seminar and other nightly demos. It just seems to have many moving parts and steps. My other concern is that MS will go with the "and now for something completely different" routine. While PHP looks difficult from a syntax point of view, it seems to have been around awhile.
It looks like an article to follow steps on with a link to a PHP solution that appears to include images.

 

[AnthonyGerrard]

https://technet.microsoft.com/en-US/library/Cc793139(v=SQL.90).aspx;
This article was written for an older 2005 version of SQL for connection to PHP.
The ratings show that the majority of readers found it useful.
Of interest is a Sample SQL Server DB & PHP to download. The 2005 article sample link points to a SQL Server 2008 sample.
https://msdn.microsoft.com/en-us/library/cc296196.aspx
PHP using Adventure Works on SQL Server 2008

If by chance you download the sample please provide some feedback.
I have not been at all impressed with the Access Web parts. I have been to a full day seminar and other nightly demos. It just seems to have many moving parts and steps. My other concern is that MS will go with the "and now for something completely different" routine. While PHP looks difficult from a syntax point of view, it seems to have been around awhile.
It looks like an article to follow steps on with a link to a PHP solution that appears to include images.

Thanks I'll take a look when I have finished the immediate task in hand! Ta

 

[AnthonyGerrard]

Cheers Rx - I'll get the example installed over the weekend to have a play around with. Have you got a complete link for the first link? Seems to have been truncated.

Thanks

 

[Gasman]

Try https://technet.microsoft.com/en-US/library/Cc793139(v=SQL.90).aspx

 

[AnthonyGerrard]

Try https://technet.microsoft.com/en-US/library/Cc793139(v=SQL.90).aspx

Thank you!

 

[Rx_]

Sorry about that, I hate it when I get truncated things. Excpcially a truncated paycheck!

I am really looking forward to hearing the results of your work. I had assumed PHP might be an option to a SQL backend. In MS Access Web, they suggest a web page with the new Access macro code, then useing the full-blown Access (locally) for administration management. All that of course using Azure.

If you are successful, feel free to PM me with a web page link. Good luck this weekend.

 

[Gasman]

Sorry about that, I hate it when I get truncated things. Excpcially a truncated paycheck!

I am really looking forward to hearing the results of your work. I had assumed PHP might be an option to a SQL backend. In MS Access Web, they suggest a web page with the new Access macro code, then useing the full-blown Access (locally) for administration management. All that of course using Azure.

If you are successful, feel free to PM me with a web page link. Good luck this weekend.

It wasn't truncated, but had an errant ";" tagged on to the url