Surely there is the need for some thinking time. Many hours of sleep lost when the brain decides to rehearse a memorable problem instead of snoozing.

Could you use code tags?

AND"+

"z.usernameman

concatenates to andz.usernameman which is invalid

Trying to generate dynamic sql?

Also have a look at Quest for SSC alike oracle forums

A point for keeping the modified always filled in >=created date is that your index search on "created or modified within the last 24 hours" works faster (only checking on...

Also the oracleversion of the backend is important as msdaora is discontinued, you better use the oracle-driver from oracle (from oracle 10 on)

impdp/expdp doesn't exist in oracle 9? Imp/exp does

I've converted the right-join in a left join (as they are rewritable),didn't feel like reordening my whole query.

Easiest is to remember (+) means: if not found add a null...

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.