Charlie Try this
SET VAR VDateTime DATETIME = (DATETIME(.#DATE,.#TIME)) UPDATE recentqimenu SET meditdatetime = .VDateTime WHERE ..... Buddy -----Original Message----- From: Charles Parks [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 5:00 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Troubles updating When I get to this line of code in a macro UPDATE recentqimenu SET meditdatetime = (DATETIME(.#DATE,.#TIME)) + WHERE stfmbr = .vuser AND primarymacro = 'qimac\cleanmn.mac' it gives an error message, "Unauthorized access to the table ...' I have confirmed that access rights have been set up for this table. What else do I need to do? Thanks, Charlie --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
