/etc/rc.local not being run on Ubuntu Desktop Install

Question

I am using Access 2007 at work. I have a main form with 5 different Tabs in the Tab Control thing. I want each of the tabs to have the same subform in them, but it filters differently based on what tab you are on. Ideally I'd like the subform to be linked to just a table, not a form or a query, but as long as it works well I'm flexible. This table is for Comments.

Main form = frm_CE
Table I want to put in as subform = tbl_AllComments

Is this possible? If not, are there any other ways at looking at this that would accomplish the same end goal?

Thanks so much

Solution

One of the commands on your /etc/rc.local must be exiting with a non-zero status. Because of the -e parameter to sh on the first line this is causing the script to exit immediatly.

You can either remove the -e or find the responsible command and fix its error.

Comments

[Admin]

I have the same problem. When I execute /etc/rc.local my script is executed but the script is not executed from rc.local in ubuntu 10.04.

[Mark3308]

Is the main form bound to a table? How should the comments be filtered? I.e. is there a relationship between the main table and the tbl_AllComments table?

[msim]

Hi, thanks for asking. The main form frm_CE is bound to tbl_CE. There is a relationship between tbl_CE and tbl_AllComments, by Loan Number. BUT, I want the comments to be filtered by Document Type, and there is no field in tbl_CE for that, nor can there be unless I rethink the whole thing.

[Mark3308]

The way the subform works is it links to one or more fields in both tables to work out the filtering

[loosecannon]

oh thats what -e does...but why would it run fine called explicitly

[Eduardo Ivanec]

I'm sorry but I'm not following, could you please clarify? Removing the -e won't actually fix the error of course, it will just make all the lines in the script execute regardless of whether there was a previous error. More like a "standard" shell script.

[loosecannon]

sorry that was sort of two comments: A realization of what the -e switch does and if i run /etc/rc.local it executes successfully, it seems like it should fail if something is going wrong