updateable query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a VB .Net application. I am using MS Access and a .mdb
database.

I have split the database located on a server operating with Server 2003. I
have installed the database front end and my .exe application and my .dll
libraries on the c: drive of a PC workstation. I have attempted to jump
through the MANY, and confusing, Microsoft Hoops involving Security and
Permissions.

When I am a Remote Desktop on the server, and I try to update a table’s
field, every thing runs OK.

When I have a Direct Connection on my PC to the server, I can read the back
end data via it’s front end. When I try to update a table’s field, I get the
dreaded MS Error : Operation must use an updateable query.

As a Remote Desktop, I can enter MS Access and change a Table’s Data. With
a Direct Connection I get the error and I can Not change a Table’s Data.

I have gone through the Security and Permissions hoops so many times I am
dizzy. What do you suggest ? ? ?
 
Make sure the backend table has a primary key then recreate or refresh the
link to it in the frontend.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I am developing a VB .Net application. I am using MS Access and a .mdb
| database.
|
| I have split the database located on a server operating with Server 2003.
I
| have installed the database front end and my .exe application and my .dll
| libraries on the c: drive of a PC workstation. I have attempted to jump
| through the MANY, and confusing, Microsoft Hoops involving Security and
| Permissions.
|
| When I am a Remote Desktop on the server, and I try to update a table's
| field, every thing runs OK.
|
| When I have a Direct Connection on my PC to the server, I can read the
back
| end data via it's front end. When I try to update a table's field, I get
the
| dreaded MS Error : Operation must use an updateable query.
|
| As a Remote Desktop, I can enter MS Access and change a Table's Data.
With
| a Direct Connection I get the error and I can Not change a Table's Data.
|
| I have gone through the Security and Permissions hoops so many times I am
| dizzy. What do you suggest ? ? ?
|
 
Thanks. That's really helpful, but another question is how do I do that if I
have multiple tabs and each tab control source should be different because
they're from different table?
 
Back
Top