Can't add record after relinking tables to SQL Server

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

I was having a problem with a query on my client's system not being able to
add a record. I transferred a fresh copy to his server via PC Anywhere and
it was ok. I made an .mde, tested it and it was fine. Finally I refreshed
the table links and was unable the add the record again. The dsn on my
local machine is the same as on the client's system, but I had trouble in
the past sometimes reading the tables until I refrehed the links. So I hope
to correct the issue. I am afraid I will run into other problems by not
refreshing.

Thanks for any help.

God Bless,

Mark A. Sam
 
Mark A. Sam said:
I was having a problem with a query on my client's system not being able to
add a record. I transferred a fresh copy to his server via PC Anywhere and
it was ok. I made an .mde, tested it and it was fine. Finally I refreshed
the table links and was unable the add the record again. The dsn on my
local machine is the same as on the client's system, but I had trouble in
the past sometimes reading the tables until I refrehed the links. So I hope
to correct the issue. I am afraid I will run into other problems by not
refreshing.
Click to expand...

When a link is made through the GUI to an ODBC source table and that source
table has no Primary Key defined then Access will prompt you for the
columns Access should use to build a local unique index. If this is not
done the link will be read-only. When you DO provide the correct column
names the link will be editable. Unfortunately refreshing links wipes this
information out and the link reverts to read-only.
 
Rick,

There is a primary key and with Indentity Insert set to yes. When this came
up, I dragged that field into the query grid and it corrected the problem
until I created the .mde and probably at the time refreshed the link. I
don't recall. I didn't really expect the problem again, so I didn't pay
attention to my procedure.

I hooked remotely to a client machine with PC Anywhere and was able to add a
record, however now a user, hooking up through Terminal Services can't
update a new record. I believe that anew record was avaialble, but the
system wouldn't let him add data to it.

God Bless,

Mark
 
Rick,

Cancel my last message. I see that this may be a permissions issue. I
tried to grant Terminal Server Users access to the DB, but was not able to.
I will take it up with the network admin.

Thanks.

Mark
 
Back
Top