Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Fortune
Starting Member
1 Post |
 Posted - 2003-07-17 : 10:36:00
|
| Hi all,I have the following problem. At my company, we have a sql server with several databases. Some tables cannot be mutated by the program, wich uses this database.Im now busy to create a program in Access to mutate this data. For example, name and adress of ah user.The problem is, that in Access i can't mutate it. The data stands on read only somehow in de sql database.How can i change this, so i can mutate data in my access program. Then other people can mutate instead of me. Now i have to mutate directly in the database, and that's something i don't want.Who can help me!?With kind regards,Peter alias Fortune |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-07-17 : 12:54:31
|
| ] mutate??? Expose it to large doses of gamma radiation. Sorry Could not resist the joke.To Update the data through Access you will 1st have to grant access Rights to the user in SQL 1st.also check the Database If it does not contain a primary/key field you will not be able to update,append or delete in Access. JimUsers <> Logic |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 12:09:58
|
| I alwasy thought of Access as THE MUTANT RDBMS FROM ANOTHER GALAXYBrett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-25 : 16:03:46
|
| Or how about the reference guide manualALIEN MUTANT DATABASE THAT ATE MY BRAINBrett8-) |
|
|
|
|
|
|
trouble with mutating information in access