My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Can you modify Source Data thru ODBC with Access?
|
|
 May 13 2005, 07:56 AM
Post
#1
|
|
|
New Member Posts: 1  |
Hi All,
This is probably a very simple question. I'm pretty new to access and obtaining source data through an ODBC. I heard that you can you modify the Source Data thru ODBC with Access. Is that true? thxs! |
 |
 
|
|
May 13 2005, 08:17 AM
Post
#2
|
|
|
UtterAccess Addict Posts: 261 From: Belfast NI |
It depends on the ODBC driver. The ODBC driver for the Sage accounting package, for example, lets you read data but does not let you change data. Most of the ODBC drivers I have seen, though, do allow you to modify the source data through Access.
|
|
|
|
|
May 13 2005, 08:17 AM
Post
#3
|
|
|
UtterAccess VIP Posts: 4,034 From: NY - USA |
Welcome to UA.
Yes - as long as the username has write access to the tables. |
|
|
|
|
May 23 2005, 09:33 AM
Post
#4
|
|
|
UtterAccess Addict Posts: 280 From: Birmingham,UK |
Hi,
I am trying to create a link between Sage Line50 v11 and Access, how did you do it/where did you get the ODBC driver? |
|
|
|
|
May 23 2005, 11:11 AM
Post
#5
|
|
|
UtterAccess Addict Posts: 280 From: Birmingham,UK |
Hi All,
I've managed to find out and create a link between Sage Line50 and Access. But my next question is the same as someone elses i think. Can i modify/add data in Sage from Access? I dont have a user name and password set up so the manual tells me to use the username "manager" and leave the password field blank. I do this and it doesn't let me edit it, can anyone help me please? Thank you. |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 05:35 PM |