No announcements
Found 3252413 threads
-
0 VotesAccess 2010: Insert records from Access query into linked SQL table
According to your description, you could use INSERT INTO statement to add a record or multiple records to a table.Answered | 4 Replies | 501 Views | Created by District9 - Thursday, May 26, 2016 8:28 PM | Last reply by David_JunFeng - Friday, May 27, 2016 5:54 AM
-
2 Votes
This recordset is not updatable - Access 2010 with linked tables from SQL Server 2008
For now, I am deleting the incomplete records from the Result table, when the form is closed.Answered | 15 Replies | 15755 Views | Created by RSNoobie - Friday, January 18, 2013 3:50 PM | Last reply by RSNoobie - Wednesday, February 20, 2013 4:14 PM -
0 Votes
Link table from SQL 2008 to Access 2007
>When linking tables from Access to SQL I use the OBDC connection by creating a specific machine/user specific data source and the wizards ...Answered | 11 Replies | 1814 Views | Created by BKreft - Wednesday, October 9, 2013 7:34 PM | Last reply by BKreft - Wednesday, October 16, 2013 11:52 AM -
0 Votes
Delete SQL 2008 Record from Access 2010
Depending on the construction / SQL of the Query and the Relationships of the Entities of the Tables used in the Query, it is possible for ...Answered | 2 Replies | 907 Views | Created by pjscott51 - Thursday, September 11, 2014 7:33 PM | Last reply by Van Dinh - Thursday, September 11, 2014 11:14 PM -
3 Votes
Simple Task - Get table from Access 2010 into Sql Server 2008
I am having a difficult time getting an Access table with 71 fields and 884046 records from an accdb database file imported into ...Answered | 7 Replies | 21667 Views | Created by davestech - Saturday, July 24, 2010 4:47 PM | Last reply by OptimalSolutions - Tuesday, February 22, 2011 12:58 PM -
0 Votes
Access 2010 with SQL and Oracle
But it is possible to use classic bound forms against linked tables or views which become the same linked tables in Access.Answered | 16 Replies | 2751 Views | Created by system243trd - Tuesday, November 13, 2012 6:26 PM | Last reply by Andrey Artemyev - Monday, November 19, 2012 12:46 PM -
0 Votes
linked table 2007 to 2010, copy record when deleted or inserted
I solved the problem by running a query that checks the differences between tables and adds the records that are not equal to the backup table.Answered | 8 Replies | 520 Views | Created by Pacheco Vieira - Friday, August 5, 2016 11:56 AM | Last reply by Pacheco Vieira - Wednesday, August 10, 2016 10:35 PM -
0 Votes
Access - SQL Server : Linked tables information
The only thing you can do: Record the usage of all tables with a SQL Server side-trace or SQL Profiler and filter for Microsoft Access ...Answered | 3 Replies | 4398 Views | Created by hydkk - Monday, November 7, 2011 10:55 PM | Last reply by Stefan Hoffmann - Tuesday, November 15, 2011 10:53 AM -
1 Votes
Dynamically Create table and insert the records from source to destination in sql query
0 Begin PRINT @X Select @f1= grp_id From @table Where Idt = @x SET @TABLENAME_1='condition_' + ...Answered | 12 Replies | 11923 Views | Created by SSQL123 - Monday, July 29, 2013 5:22 AM | Last reply by Amit C A - Wednesday, July 31, 2013 5:20 AM -
0 Votes
3155 Insert into Linked Table error
When I identified all the MS Access Forms being used to retrieve data from this one table I saw some horrendously resource hungry queries that were causing the ...Answered | 4 Replies | 15226 Views | Created by SamGribbles - Wednesday, February 5, 2014 3:37 AM | Last reply by SamGribbles - Tuesday, February 11, 2014 10:45 PM -
0 Votes
Access Navigation Bar counter (record x of y) slow to load in Access 2013/2016 with SQL linked tables
Answered | 3 Replies | 371 Views | Created by CHAM01 - Monday, October 9, 2017 10:31 AM | Last reply by Terry Xu - MSFT - Wednesday, October 11, 2017 8:37 AM -
0 Votes
Microsoft Access Not finding correct Linked SqlServer records
The solution was to setup unique indexes on the SqlServer side, relink the SqlServer table in Access (Link Manager) and the queries seem to be running as ...Answered | 3 Replies | 1948 Views | Created by spamcw - Tuesday, December 31, 2013 12:53 AM | Last reply by spamcw - Wednesday, January 8, 2014 6:28 PM -
0 Votes
Sorting in Access 2010 with linked table to SQL SERVER EXPRESS 2014
http://stackoverflow.com/questions/30602825/access-2013-linked-table-timeout-error Regarding the slowness, is ...Answered | 1 Replies | 1182 Views | Created by alloua26 - Wednesday, November 4, 2015 1:25 AM | Last reply by Eric__Zhang - Wednesday, November 4, 2015 7:05 AM -
1 Votes
Can't link Access table to SQL Azure
forum=windowsazuredata ...Answered | 2 Replies | 2081 Views | Created by kyle ls - Monday, April 14, 2014 8:57 PM | Last reply by kyle ls - Tuesday, April 15, 2014 7:54 PM -
0 Votes
Write conflict on SQL database from Access 2010
The thread changed to the problem you observed on your SQL Back-End + Access Front-End very quickly from post #6 where I first mentioned the (SQL Server) ...Answered | 2 Replies | 1995 Views | Created by Bruce Hulsey - Wednesday, March 12, 2014 7:05 PM | Last reply by Van Dinh - Thursday, March 13, 2014 1:26 AM -
1 Votes
Insert Query not inserting new record at the end of table.
This will not guarantee that if you select the records from the table without specifiying an ORDER BY clause that you will see the columns in the order ...Answered | 9 Replies | 8739 Views | Created by FJ2008 - Tuesday, September 20, 2011 7:39 PM | Last reply by FJ2008 - Tuesday, September 20, 2011 9:27 PM -
1 Votes
Error updating an ACCESS table in MS ACCESS 2010
I'm running this query in ACCESS 2010:UPDATE [CSC DEED TABLE] SET [CSC DEED TABLE].Doc_type = ...Answered | 5 Replies | 1653 Views | Created by malex00 - Monday, March 25, 2013 7:06 PM | Last reply by New_Ibro - Tuesday, March 26, 2013 12:16 PM -
1 Votes
Refresh Linked SQL table in Access Web App
If you created your web app from local Access tables and a linked SQL Server (not Azure) table, then I believe the process would have imported ...Answered | 12 Replies | 3623 Views | Created by SpaceData - Thursday, June 4, 2015 4:06 PM | Last reply by Edward8520 - Thursday, June 11, 2015 9:57 AM -
3 Votes
Import data from Sql tables to Ms access
From first link : 1.We should have tables structure already in MS Access file to insert row.Is there any way to ...Answered | 10 Replies | 10819 Views | Created by Tej kamal - Thursday, January 24, 2013 12:02 PM | Last reply by Tej kamal - Monday, January 28, 2013 4:22 AM -
0 Votes
How to access Oracle table from SQL Server ?
Creating a linked server is the way to access Oracle tablesMany Thanks & Best Regards, HuaMin ChenAnswered | 7 Replies | 19586 Views | Created by Sach Vaidya - Wednesday, August 24, 2011 7:05 AM | Last reply by Jackson_1990 - Tuesday, August 30, 2011 3:03 AM - Items 1 to 20 of 3252413 Next ›
No announcements
