Add New Table

[Keith Hubert]

Hi All,

I needed a table to be looked at, as it was part of a big app I zipped up just the table concerned. I was then told that the table could not be opened as it was bound to another database.

So I created another database and tried to Add that table with all the associated files. I got the following message : Mytable "Cannot be added to this database because it is secured and bound to another database" .

Is this a new feature from Alpha? Does anyone know how to unbind a table? If I create a new table on my machine how do I send that to a client?

Any suggestions please.


RegardsKeith HubertAlpha Guild MemberLondon.KHDB Management Systems

[AaronBBrown]

RE: Add New Table

You must have created the table within a database that has security setup. In order to prevent users from circumventing security by adding a table to another database, tables become bound to the database they are a member of....To unbind a table, you need to add it back to its original database and then remove security, *or* drop the table from the original secured database.

If this is a new table you are sending to a user, create it from within an unsecured database.

[Keith Hubert]

RE: Add New Table

Aaron,

Thanks for reply.

Yes you are correct, I had put a master password on the database to demonstrate how security works to a client. Now I know what else it does.

RegardsKeith HubertAlpha Guild MemberLondon.KHDB Management Systems

[kumargroup]

problem with "bound"

You must have created the table within a database that has security setup. In order to prevent users from circumventing security by adding a table to another database, tables become bound to the database they are a member of....To unbind a table, you need to add it back to its original database and then remove security, *or* drop the table from the original secured database.

If this is a new table you are sending to a user, create it from within an unsecured database.

I am getting this error everytime I run an Import. Say I have 4 imports that essentially replace 4 existing databases (dbfs) in my app. Each time an import runs within a script, the error (or the dialog box) pops up. Clicking on "OK" will continue to the next import function and the table seems to be updated but someone has to click ok 4 times in this case. Is there a way to have security and still have the import operations work without the additional prompts.

as always, all info. is greatly appreaciated.

kris

[AaronBBrown]

Kris,

I cannot reproduce this issue. Please provide more information about your database setup. Does the table being overwritten belong to more than one database?

I am getting this error everytime I run an Import. Say I have 4 imports that essentially replace 4 existing databases (dbfs) in my app. Each time an import runs within a script, the error (or the dialog box) pops up. Clicking on "OK" will continue to the next import function and the table seems to be updated but someone has to click ok 4 times in this case. Is there a way to have security and still have the import operations work without the additional prompts.

as always, all info. is greatly appreaciated.

kris

[Ed Barley]

Hi All,

I had this problem also with a couple of operations that were added to a data base.

I believe the sequience of events were like this. I applied security to the Data Base. Added an import operation, and such. Then the Security error message came up.

At the time there was one password for the entire data base. Removed the password, and re did security...............At that point the error message did not come up again.............You might give that a try to see if that fixes the messages.

Ed