I understand you want to stay with access for whatever reason. But consider how much trouble this is for you.. Are you sure you aren't able to use a different database (or convince your client that he should move up)? I mean, access can only handle 1 user at a time anyway.. That alone should be a good reason to move up (also, access costs money. MySQL doesn't).
I know (believe me.. I know) that you may not have a say in this. But consider informing whoever choose to stick with access (or start with it) that they are making the wrong choice. Keith McGee wrote: >> ORDER BY Rnd(fld_page_ID) > > This command keeps pulling the same order, even if I close the browser. If > they go back to the main page I would like possibility of having a different > news item appear. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4