You're welcome.

No, my idea...

sumit.joshij (4/6/2010)

---

At least we all of you have to check the ORCALE database, those who are in favor of maintain the FK constrain.

At least they(ORACLE corp) can have the knowledge...

Set up either a script or job that the IT people need to run before they do a shutdown. Maybe a simple VB.NET Windows app with a "pre-shutdown check"...

Can you set up the Access app to handle that for you? I used to manage an Access-on-SQL (sounds like that should be an English town name) application. ...

Um, this may be a stupid question, but is your server suddenly shutting down spontaneously on a regular basis?

If I need something to run before the server shuts down, I...

jcrawf02 (4/6/2010)

---

GSquared (4/5/2010)

---

Business users could carry a few grams of flash drive, and keep a backup online (something like Carbonite.com), instead of a laptop, if they so desired. Hotels...

You're missing a close-paren after the size on the x3 line.

In that case, if you delete from table1, it will delete from table2, which will then delete from table3. At the same time, you're telling it to delete from...

I did a Bing search for the exception message, and found this: http://ora-12154.ora-code.com/

Does it help?

I don't mind being shown features that aren't in common use. There's always the possibility that they aren't in common use because not enough people have been shown them....

This isn't a simple situation. It's not really something we can walk you through on an online forum, unless you can take a month or so of trial and...

I'd have to see a sample of how the data is put together before I could suggest anything. That and I'd need to know what method you are using...

IF doesn't work that way. It tests a condition and executes or skips the statement after it based on that condition.

You'll be better of building a cursor and having...

What does the wait data say?

The usual causes are either the disk is full, or the log file has a maximum size and has reached it.

The usual solutions are run...