Here is a snippet of startup code I have developed to front an Access database
with R:BASE using DSNLESS connections.
SDETACH ALL NOCHECK
SET ERROR MESSAGES ON
SET VAR vtaccesspath=('\\mypath\2009\' + .vtfilename+'.MDB')
IF CHKFILE(.vtaccesspath)=0 THEN
GOTO f_again
ENDIF
SET VAR vsattachcmd=+
(';driver={Microsoft Access Driver (*.mdb)};DBQ=' + .vtaccesspath)
SCONNECT .vsattachcmd
SATTACH acocmp USING id alias +
idcocmp,statuscmp,recordtypecmp,titlecmp,abbrevcmp,listposcmp,anchorcmp,+
sanchorcmp,flagscmp,calccmp,ratecmp,basiscmp,formtypecmp,boxcmp,reportcodecmp,
----- Original Message -----
From: "Michael J. Sinclair"
Date: Sunday, March 7, 2010 7:57 pm
Subject: [RBASE-L] - How do I avoid the Rbase Connect Screen in Rbase 7.6
To: [email protected] (RBASE-L Mailing List)
> Hi all,
>
> I am trying to save a few key strokes. I want to add new rows
> from a table in a foreign database to my currently open
> database. My syntax is...
> APPEND patinfo_dup TO patinfo WHERE patnumbr NOT IN (SEL
> patnumbr FROM patinfo)
>
> The code works fine, but each time I do it, I get a pop screen
> called R:BASE Connect. I think it wants me to enter the USER ID
> for Data Source: and Password for Data Source:
>
> Instead, I just click the OK button (I don't enter any thing in
> the 2 empty boxes) and the program advances normally. What can I
> do to prevent this pop up screen from showing up?
>
> Mike
>
