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 |
|
charles101
Starting Member
16 Posts |
 Posted - 2007-02-26 : 23:08:21
|
| Hi, I have a Access database and formsOne form is returning a datasheet view based on a dynaset query, the property off the form is allow edits and no locking. i am able too edit directly onto this formI have recently upgraded the database too SQL server tables and modified the query to be a pass through query. The same Access form is returning the correct data however I can no longer modify the data on the form. Is there something else I must do or is there a workaround.Thanks |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-02-27 : 09:33:37
|
| A pass-through query or a linked table? A pass-through query is read-only, it is just a query or stored procedure that returns data. A linked table can be updated by Access essentially the same way a local table can in Access, and you can write regular Access queries against the linked table.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
charles101
Starting Member
16 Posts |
Posted - 2007-02-27 : 17:27:12
|
| Im trying a pass through as the linked query runs really slowly, i noticed the pass through does what i need speed wise but doesnt allow update !!! know anyway too speed up the execution off a linked query without rewritting the query itself?Also im using ADO as the data access method instead off the native access Jet engine.. Can I have a combintation off ADO and Jet access in the application. ie where i have the link query use Jet. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-02-27 : 18:21:04
|
| You can do whatever you want, but you'll need to write the code. Of course you can use ADO to insert/update/delete data, but you have to write the INSERT/UPDATE/DELETE statements yourself or create and call stored procedures to do the work.With linked tables, be sure that you are doing thing optimally and efficiently if speed is a problem; you need to filter down the tables at the server, avoid joins to local Access tables, be sure all tables involved have primary keys, and so on. Linked tables can be very fast, and you can let Access do most of the work, but you need to be smart about how you use them and you need to think logically about ways of reducing the amount of data that needs to move round-trip in order for Access to evaluate queries and to bind data to forms and reports.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
charles101
Starting Member
16 Posts |
Posted - 2007-02-27 : 19:05:50
|
| Jeff,Is there a way off using a datasheet view in Access ADP which is edittable ?To reprogram a form for this would be alot off work, it would be good if there was a way too be able too edit the datasheet which is being called by a pass through query, from what you have said it doesnt seem possible. How does access deal with editable datasheet in an ADP? Also I cant seem too create a link table once the project has been converted too an ADP, this seem not possible either. |
|
|
|
|
|
|
|
|
Editting data on Access form using pass through