Some tables can be updated and others can't

[MkIIISupra]

Hello, I am now working for UCSC! Yes! Anyhow I have an old energy management database called Faser that I need to interface with. What I am doing is linking Access to the Faser tables via ODBC. No problems there.

The problem comes from when I am trying to add a record or update records in some of the Faser tables via Access. Some of the tables (about 90% of them) I can add, delete and update records no problem. But there are a couple (one in particular I have to change a date on 26,000 records) that I cannot. Any ideas as to why this is? Thanks!

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[rjoubert]

I'm not familiar with Faser, but it sounds like the rights are different on those tables you cannot update. You may only have read access to those tables, while you have read/write access to the ones you are able to update. Is there a DBA that manages that Faser database?

 

[MkIIISupra]

Ironically... it's now me! And I am not familiar with it either, I have a tool called iSql that comes with the Faser DB system. I am a bit rusty on setting table permissions and such via SQL... care to help?

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[TheAceMan1]

How are ya MkIIISupra . . .

I'd [blue]make tables in Access to receive the imported data[/blue]. Now that the data is purely access, options are yours . . . that is unless
there's a reason to maintain the UCSC tables? . . .

[blue]Your Thoughts?[/blue]

See Ya! . . . . . .

 

[MkIIISupra]

I have to keep the old tables up to date for a while. We are in a transitional period at the moment. Right now we are looking at a new databasing application to replace Faser. But until then I need to keep the Faser tables current.

I am using Access as an interface due to the ability to create stored Queries and procedures. Something that is lacking in Faser. Also with the Access interface it's easyier to interact with the data in the tables (easier to goof up too, but then again easier to recover as well!)

Alhtough I do have copies of the tables I need in Access for working purposes, I still need to be able to update the main DB tables in Faser so that we all have access to the most current data. Faser does some thigns that Access can't (without some major work... and that isn't feasible) so that is the pickle barrel I am swimming in now.

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[MkIIISupra]

Okay so I have been doing some digging around and here is what I have to deal with.

Sybase iSQL 5.5.05 Build #2509.

I found a good resource on Sybase <A href="

http://manuals.sybase.com/onlineboo...=66?target=%N_577_START_RESTART_N%">Here</A>

but some of the commands don't work with the older DB. I am on the right track but I have zero experience with Sybase... although it looks easy enough. But I am stumped. I ran a grant command for updates and deletes as well as adds but it doesn't seem to have changed the table permissions. I tried to run a command to display the table users and permissions without success. Any ideas?

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[MkIIISupra]

Found the answer! When I was linking the Sybase tables I failed to ID the PK of 5 of the tables. So Access couldn't and wouldn't let me do anything but read the tables (data). Once I linked and ID'd the PK of each table I was allowed full access and so now I am on my way!

Thanks for the assistance!

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[MkIIISupra]

Okay one issue resolved a new one arises...

When I try to add or modify a record in a linked Sybase table I get the following error:

ODBC --insert on a linked table "DBA_Meterhst' failed.
[Sybase][ODBC Driver]Unable to connect to database server: authentication violation (#-98)

When I click help to try and get some direction or answer the help menu does't contain any data at all, if it even starts.

I am using Access 2000 (9.0.3821 SR-1) on Windows XP Pro.

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!

 

[abaldwin]

As someone previously stated, I too think this is a security issue at the DB level. Does the Sybase system you run have any GUI tools such as Enterprise manager with SQL? If so I would explore the security/db rights from there.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[MkIIISupra]

No, I can't seem to find any tools that fit the description. Looks like I am stuck. Only solution is to create a parallel DB in Access until I can resolve this. Thanks.

One by one the penguins return my sanity, as day by day Microsoft steals my sanity!

OpenSuSE 10.0 kicks fanny!