Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Linked tables

Posted on 1998-08-17
1
Medium Priority
?
224 Views
Last Modified: 2010-03-19
I am running an access front end to retrieve data out of SQL. The linked table are running extremely slow, so I want to do some programming to speed up things.  I have some stored procedures that I am running in Pass Through Queries, but as far as I am aware of they are not updateable. What would be another solution to having updateable records?
0
Comment
Question by:rvindust
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
Victor Spiridonov earned 40 total points
ID: 1089585
If you want to update records using forms or queries, the only solution is linked tables. Otherwise you can use VBA code and pass-through queries, to execute stored procedures, that update records.

0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question