January 31, 2011 at 1:37 pm
How can I edit the data in tables using an ADP?
I am imported tables to sql server via the import option and I would like to edit those tables via access. Is that possible?
Charles
January 31, 2011 at 2:19 pm
Why would you choose to edit a table with Access instead of sql server? There will not be any way to do this from access other than running a sql script.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 31, 2011 at 2:23 pm
I need to create a solution that users can add info to the database as well via access data project.
January 31, 2011 at 2:38 pm
Adding data is a whole different beast than editing tables. 😉
You should be able to create a stored procedure on the sql side and have Access call it. Was all the data in Access and now it is moved to sql server but the existing UI is still in Access?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 31, 2011 at 2:41 pm
No, the data was imported via the import tool into SQL Server and I wanted to edit the data that had been imported.
January 31, 2011 at 2:43 pm
What has me puzzled is that I can create new sql server tables in access and edit them fine but, when i import them via the import tool, I can't edit them.
Do you think it has something to do with permissions?
I am the dbo.
January 31, 2011 at 2:43 pm
Can you just create an update in sql? You are going to have to create update, insert queries anyway.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 31, 2011 at 2:47 pm
I am not sure. It would have never occurred to me to use Access to create tables in SQL. Is there a reason you can't use sql to to your updates? Is there a UI in Access that you are trying to use?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 1, 2011 at 3:27 pm
blackwell (1/31/2011)
What has me puzzled is that I can create new sql server tables in access and edit them fine but, when i import them via the import tool, I can't edit them.Do you think it has something to do with permissions?
I am the dbo.
Make sure the tables you imported have primary keys set in sql server. If there is no PK on the table, Access will freak out.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 1, 2011 at 6:26 pm
I am also having a problem of editing a SQL table once I create it. For example, if i save a table before I set a pk, it won't let me go back and make something a pk. it says that i have to drop and recreate the table????
February 1, 2011 at 6:32 pm
Set the PK in SSMS. When you reopen your Access project it should reconnect and recognize the PK.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
February 1, 2011 at 6:34 pm
SSMS won't let me resave the table. 🙁
February 1, 2011 at 7:03 pm
ok, let's try from another angle. type this in a query window in SSMS and execute it. let me know the response.
alter table [table_name] add primary key ([column_name])
of course, replace the table_name and column_name with yours.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply