Btrieve Owner

[Johnf]

I use a commercial software package that uses Btrieve/Pervasive SQL. There are times that I need to write an additional application to perform some small function. The vender provides the DDFs but they are password protected, so if I want to view a file using Access, it asks for a login name for the database and a password. If I use VB or some other program to perform some function to a particualr table, I must first export the table and then create a new table with no "owner" and import the data to it. Then I don't need to provide an owner name, and if their software provides one, sinse there is no owner it ignores it.
Question is, is there a way to determine an owner name for a table or a valid user name for the DDF or a "hack" to change them without knowing them, or some other method to simplify this process?

 

[mirtheil]

Are there owner names on the Btrieve files or the DDFs themselves? By default, there are owner names on the DDFs but that's to prevent random out of sync changes to the DDFs themselves.
If the Btrieve files have owner names, you're going to need to get the owner name from the commercial application or continue using the method you're using now.
If only the DDFs have owner names, you shouldn't need to use a password or login name. VB and Access should be able to access the tables without any problem. Mirtheil
mirtheil@mirtheil.com
Custom VB and Btrieve development.

 

[amod]

I am VB programmer.
I have connected vb & pervasive thru. ODBC connection.
I have used ado connection.

when recorset.open statemenet encounters
& if that table in database is open then it gives me msgbox "File Locked"
and vice versa.

can u help me!!