Here is my problem.
-I've set up an progress 10.1A database named: 'ontwikkel' with the following table: 'personen'.
-I want to acces this database within microsoft ACCES2007 so I've used a ODBC.
-In ACCES I can connect to the database but I can't acces the table 'personen'. -> error: 7747
-So I thought that I have to GRANT the table.
-I typed the following in a procedure:
"grant select on personen to tyas." (where personen=tablename and tyas=username)
-When compiling the error says: Table personen does not exist or cannot be accessed. (962)
(I also tried varations of statement like "grant select on pub.personen to tyas."
"grant select on ontwikkel.personen to tyas.")
-It looks like the table: 'personen' does not exists but in the data dictionary it does. The strange thing is that when I set up an connection with "FlySpeed Query Tool"(an SQL explorer) the table 'personen' doesnt exist either.
I think that when i GRANT the table, the problem is solved and I can connect to the database and tables within ACCES2007. So... who can help me GRANT these tables......
your help will be appreciated.
-I've set up an progress 10.1A database named: 'ontwikkel' with the following table: 'personen'.
-I want to acces this database within microsoft ACCES2007 so I've used a ODBC.
-In ACCES I can connect to the database but I can't acces the table 'personen'. -> error: 7747
-So I thought that I have to GRANT the table.
-I typed the following in a procedure:
"grant select on personen to tyas." (where personen=tablename and tyas=username)
-When compiling the error says: Table personen does not exist or cannot be accessed. (962)
(I also tried varations of statement like "grant select on pub.personen to tyas."
"grant select on ontwikkel.personen to tyas.")
-It looks like the table: 'personen' does not exists but in the data dictionary it does. The strange thing is that when I set up an connection with "FlySpeed Query Tool"(an SQL explorer) the table 'personen' doesnt exist either.
I think that when i GRANT the table, the problem is solved and I can connect to the database and tables within ACCES2007. So... who can help me GRANT these tables......
your help will be appreciated.