473,320 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

I can't figure out to make a form bound to a SQL temporary table editable.

Using a Access project, I create a temporary table in the SQL tempdb database and use it to edit records uploaded from the permanent table. When the user is finished editing, the record is written back the permanent table. This is great except only I (DBO) can modify the data on the bound form. Other users can only read but not modify the data in the temporary table. I don't think you can't grant rights to a temp table so I can't figure out how to get this working. Does anyone have an answer
Aug 23 '09 #1
3 2075
ADezii
8,834 Expert 8TB
@RobertC
Hello RobertC, and welcome to Bytes. I am not a SQL Expert but the way that I see things is that by being the Creator of the Temporary Table, it belongs to you as DBO and no one else. Your two possible options, although one may not be viable are:
  1. Assign Users needing permissions to modify data in the Temp Table to the sysadmin Fixed Server Role, but be totally aware of this implication.
  2. As the DBO, you may be able to explicitly GRANT Permissions to specific Users/Groups on this Temporary Table, then REVOKE them when required. GRANT and REVOKE can be accomplished programmatically.
  3. I would also suggest posting this in the SQL Server Forum where you would probably obtain a much better response. I'll jump over there now, Link to this Thread, and see if some of the gang can help.
Aug 23 '09 #2
ck9663
2,878 Expert 2GB
@RobertC
But can the other see the temp table? Temp table is usually session based, unless it's a global temp table. May I know why you need a temp table for your process? Maybe it can be done using another technique.

--- CK
Aug 24 '09 #3
CK, Thanks for the reply.
The other users can see the data on the bound form but cannot modify any fields. This is true even if the table is directly opened in the database window. It is a session base table (#tblLoads). I would like to use the temp table because I can let the users modify the data disconnected from the live data and when they are finished I can update the live data. I prefer this type of editing this to using the Access basic form which I find wide open and hard to control the user actions with the data.
Aug 25 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Lyle Fairfield | last post by:
I created a new MS-SQL Database, "TestODBC". I made Table1 and StoredProcedure1. I made an ODBC DSN for that MS-SQL Database. I created a new AccessXP mdb, "TestODBC". I linked to the...
6
by: B Blue | last post by:
here's the situation: a produce dept at a grocery store needs to generate a weekly sheet for ordering. This is how it looks: 5 columns across with the following headings: Product Description,...
7
by: Megan | last post by:
Hi everybody- I inherited a database that somehow uses a bound combo box as a record selector. Let me give you some background. The form is based on data from 2 tables. The first table, Person,...
3
by: S P Arif Sahari Wibowo | last post by:
Hi! I would like to make an editable continous form, where most fields will be from table A and editable, except 1-3 fields are a glimpse into table B and uneditable. Table A relate to table B...
2
by: justplain.kzn | last post by:
Hi, I have a table with dynamic html that contains drop down select lists and readonly text boxes. Dynamic calculations are done on change of a value in one of the drop down select lists. ...
0
by: simon.kravis | last post by:
I've been struggling with getting this message when I tried to change the design of one of about 50 tables in Access 2000 database, with no forms open which might be bound to the table, no queries...
9
by: Haas C | last post by:
Hi all! Is there anyway I can override a value in a calculated field on a form? For example: I have a form which displays the following fields based on a query: Premium Due field has the...
2
by: troy_lee | last post by:
I have two tables. The PK from the parent table (Table 1) is a FK to the child table (Table 2) with a one-to-many relationship. On my form, I use a query to return some data to unbound fields...
1
ADezii
by: ADezii | last post by:
Permissions on a Temporary Table in tempdb
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.