Try

X.abc=Y.abc(+) (side with nulls) => X LEFT JOIN Y ON X.ABC=Y.ABC

X.abc(+)=Y.abc => X RIGHT JOIN Y ON X.ABC.Y.ABC

SELECT count(*)

FROM employee_master e

INNER JOIN client_master cl

ON e.rm_code=cl.rm_code

INNER JOIN branch_master b

ON...

1. Instead of saving to ms acces, have msaccess link your tables

2. Have a look at replication (some tables)/mirroring (whole database)

Be sure to question the questioner.

I suppose when the game starts, the player sees 4 pictures (giftboxes?). One of the closed boxes contains the mouse, another one the stop-sign....

SQL2000 SP4 (till the hardware breaks, no DTS), SQL2005 & SQL2008 (not yet R2). All standard or express editions. Next to Oracle 9 and 10.

I'm back to one screen (1920x1200 19") on my laptop till windows rearranges/remembers the windows when the extra monitor is missing/reattached (perhaps winsplit revolution could help).

With windows 7 you...

Seems it is a multivalued field relating to more records. Have a look at

http://blogs.office.com/b/microsoft-access/archive/2007/08/24/adding-removing-and-saving-files-from-the-new-attachment-field-in-access-2007.aspx

where they mention add/saving/removing attachments in vba.

Not supported in 10g as it was introduced in 11g according[/url]

Have the default database login for the user changed to their database? Unless they set it in their connection setting.

I could be that the oracle 11 client is limited to Oracle 9.

*

Have to find my oracle support login as it is on metalink

not sure if there were servicenames in 7.2, it is probably a SID.

What are the results of oracle basic connectivity testing?

in command prompt:

tnsping myoldandtrusty

->shows location of the oracle tnsnames.ora location

->tries...

ALZDBA (9/18/2011)

---

SQLRNNR (9/18/2011)

---

ALZDBA (9/18/2011)

---

Lynn Pettis (9/18/2011)

---

bitbucket-25253 (9/17/2011)

---

Ninja's_RGR'us (9/17/2011)

---

Hey guys (als), I just got a bank offer for a 70% / 30% sql svr / oracle environement.

Now all I know about...

I would go with replication for the non-modified tables.

ETL (ssis?) for the modified.

Last kind was a weekly restore from live to dev.

Everything the developers wanted to be kept would be...

Congratulations Jeff! :smooooth:

Haven't heard of such.

What is the particular view name?

Is create view running inside a transaction? (perhaps rolled back by end of connection).

If you create a dummy view with the same...

Interesting opinion on moving things to the cloud.

I'm for keeping the current and historical separate for disaster-recovery situations (smaller database -> faster recovery, even other backup model (full vs differential)).

If...