jGiblets

Found an answer. http://oakleafblog.blogspot.com/2010/07/linking-microsoft-access-2010-tables-to.html

Thank you for the replies! I would heed your advice (campfire) gladly, however, I've been told in no uncertain terms that we are sticking with Access. My job is just to make the round peg fit in the square hole. Here's my next question. Can I do this without conversion? I just want the web to pull info, not write it. This is most likely my own naivete, but it would seem to me that if the db info is there and all I really want is read access to the tables, couldn't I just write simple select commands based on user input? Would that work in any markup (including asp)? *edit* I am thinking that this last modification might move this out of an mssql question, would it be better to post this somewhere else? */edit*

I'm taking on a big project for work and I could really use some input as to the best way to proceed/set things up. The company uses Access 2010 (with about 15 years of database information stored). Access controls just about every step of our workflow (Inventory, customer management, sales, shipping, tracking, reports, etc...) and now we want to go on the web. The goal is to create a dynamic website that will pull information from inventory tables at a users request and display in the browser. At the moment, the project won't require (or allow) database changes from users (no user accounts or personalized pages). Just little drop downs that let them select the part, size, and other to see size, specifications and availability. Assuming that we convert the database to MSSQL using the upsize wizard in Access (and not Sharepoint) so that the end result is an Access front end calling on a MSSQL database, will I still be able to use PHP to get information? I'm confused and crunched for time. Will this setup work? Access 2010 modified by employees -> Linked to MSSQL database -> results displayed at call in web browser by customers

I like this idea, but is there a limit, or tradeoff, when it could slow things down? What if the OP's site had 6 pages and each page pulled 12 HTML content elements via PHP variables (or include/require) and each page had 3-5 style sheets attached. Would visitors experience any delay in pulling all that content vs HTML + PHP on the page? Related, is there a reason to choose echoing $variables instead of using include()/require()?

Never mind, after sleeping on it, I think I can answer my own question. There is no way to call the original values after the have been passed by reference because the $variable has been assigned a new value and only exists in that form.

Ok, I think I'm following you. Adding the "&" reference is changing the $a1 and $b1 variables. This made a lot more sense when I put the reference marker on the "addonetwo" function and then added a third statement that incremented the returned output. $a1 = 15; $b1 = 20; echo addone($a1, $b1); echo "<br/>"; function addone($n1, $n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; }; echo addonetwo($a1, $b1); echo "<br/>"; function addonetwo(&$n1, &$n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; } function addonetwothree($n1, $n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; } echo addonetwothree($a1, $b1); ?> Then the output becomes: 17 22 17 22 19 24 You all are great! Thank you for the help. One related question. Let's say this was a longer more complicated function with other increments, how would I call back to the original $variables even after they had been incremented and changed. Let's say I wanted to add a "addonetwothreefour" function: function addonetwothreefour($n1, $n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; } and have it return: 17 22

Hi all, I'm trying to understand passing by reference. Here is a copy of the code and the results: <?php $a1 = 15; $b1 = 20; echo addone($a1, $b1); echo "<br/>"; function addone($n1, $n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; }; echo addonetwo($a1, $b1); function addonetwo($n1, $n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; } ?> The result output is: 17 22 17 22 If I change the code to add "&" before the "addone" function: function addone(&$n1, &$n2){ $n1 = $n1 += 2; $n2 = $n2 += 2; return $n1 . " " . $n2; }; Then the output is: 17 22 19 24 I don't understand what's going on. Why is the "&" incrementing the changed variable and in the first example it's incrementing the variables as defined.