Opening a MS Access table in Script

Hi,

Your website has been most helpful.  I have made an alias for my access table in Paradox and put it's tables in the datamodel.  I can run queries, but not open tables from the developer interface.

I want to be able to get the table data in script. Below is a script that opens my table successfully.  But, whenever I issue the db.open a Message box pops up to ask for a username and password  (which my Access databse doesn't have). Is there a way to open the Access table without having that message box pop up?

var
    db database
    tc tcursor
endvar
    db.open("AliasName")       
    tc.open("tableName",db)

endMethod

Thanks,   Sue

Try this:

var
  db database
  pa dynarray [] string
  tc tcursor
endvar
  pa["PASSWORD"] = ""
  db.open("AliasName",pa)
  tc.open("tableName",db)
  ...etc.

Logically, it seem you should have a pa["USERNAME"] = "" before the db.open() but I have never needed it.

See the online help on Database Type for more open() syntaxes.

-Al.

From the Paradox main menu, select Help | ObjectPAL Reference Topics
Click the Index tab, enter "database type"
Click on the "open" link, examine syntax 5
(Leave out the second optional "[ const ses Session, ]" argument)

To see what parameter names (besides "PASSWORD") may be used in the "[ const parms DynArray ]" argument, open the BDE configurator (BDECFG32.EXE) or the BDE administrator (BDEADMIN.EXE) and select the appropriate driver for the database.

-Al.

That worked great  ---  Thanks.

The reference I have didn't have the extra parameter for the open method for a database.  Is there an online up to date reference that I could peruse if I get stuck again?

Or else I'll just ask here....

Thanks again!

Sue

So, a wierd thing....

When I open the script for editing, and then run the script, it works great.  If I double click it from the project viewer, it brings up the message box.

Any ideas on how to get it to work from the project viewer?

Thanks,  Sue