| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
If your tables are linked, no refresh is required.
If your tables are in Access and were created by importing the data from your external source(s), then yes, you'll need to write a routine to refresh the imported data on whatever schedule you want. Nothing is built into any version of Access to do this for you. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Prince" <(E-Mail Removed)> wrote in message news  7482F4E-0C96-44B6-B597-(E-Mail Removed)...> Thanks for early reply Jeff, > I am clear about first one but my second question that > "Do we need to write a program to automatic import data from SQL server on > daily basis on same time Or we have some builtin tools in access" > I am sorry it was not clear I didn't explain in detail, > > It was not from SQL server, I need to import some data in 4 - 5 programs > on > daily basis which are linked by ODBC with history server(And I import data > from ODBC to Access Database on daily basis). I want to make that process > automatic, Do I need to write some routine OR we have some builtin tools > available in Access 97? > > Thanks for help all the time. > > AA > > > "Douglas J. Steele" wrote: > >> Depending on what you're doing with the data, you may see slower >> performance. For example, if you're doing queries that join multiple >> tables >> together, with criteria, more data than's required may be sent to the >> client >> to resolve the query. >> >> As to your second question, no import of data is required: you're working >> with the actual tables in SQL Server. If you chose File | Get External >> Data >> | Import..., then you'd have to worrying about refreshing the data in >> Access. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "Prince" <(E-Mail Removed)> wrote in message >> news:C5E64442-700A-495F-B70B-(E-Mail Removed)... >> > Hi, >> > >> > Thanks for answer, I really appretiate your quick and useful reply it >> > will >> > help me alot. >> > I also wants to know that: >> > >> > What would be the processing speed as compare to Access's own tables? >> > >> > Another Question(related to that link): >> > >> > Do we need to write a program to automatic import data from SQL server >> > on >> > daily basis on same time Or we have some builtin tools in access? >> > >> > Thanks agin for your help. >> > >> > Amir >> > >> > >> > >> > "Jeff Boyce" wrote: >> > >> >> Create a Data Source Name (DSN) using the ODBC driver for SQL-Server >> >> (or >> >> for >> >> whatever SQL database you are using). Then use File | Get External >> >> Data >> >> | >> >> Link ... and use the ODBC 'type' file to connect to the SQL database. >> >> Pick >> >> the DSN you created. >> >> >> >> NOTE: you will have to have permissions (user/password) to the SQL >> >> database >> >> to "see" the tables and views. >> >> >> >> -- >> >> Regards >> >> >> >> Jeff Boyce >> >> Microsoft Office/Access MVP >> >> http://mvp.support.microsoft.com/ >> >> >> >> Microsoft IT Academy Program Mentor >> >> http://microsoftitacademy.com/ >> >> >> >> Microsoft Registered Partner >> >> https://partner.microsoft.com/ >> >> >> >> "Prince" <(E-Mail Removed)> wrote in message >> >> news:CF08652A-C890-4E0B-AD07-(E-Mail Removed)... >> >> > Hi All, >> >> > >> >> > Is there any way that we can directly link Access programs with SQL >> >> > database?? Instead of using access database use SQL tables ?? >> >> > >> >> > thanks in advance >> >> > >> >> > AA >> >> > >> >> > >> >> >> >> >> >> >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thank you so much for your help.
"Douglas J. Steele" wrote: > If your tables are linked, no refresh is required. > > If your tables are in Access and were created by importing the data from > your external source(s), then yes, you'll need to write a routine to refresh > the imported data on whatever schedule you want. Nothing is built into any > version of Access to do this for you. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "Prince" <(E-Mail Removed)> wrote in message > news 7482F4E-0C96-44B6-B597-(E-Mail Removed)...> > Thanks for early reply Jeff, > > I am clear about first one but my second question that > > "Do we need to write a program to automatic import data from SQL server on > > daily basis on same time Or we have some builtin tools in access" > > I am sorry it was not clear I didn't explain in detail, > > > > It was not from SQL server, I need to import some data in 4 - 5 programs > > on > > daily basis which are linked by ODBC with history server(And I import data > > from ODBC to Access Database on daily basis). I want to make that process > > automatic, Do I need to write some routine OR we have some builtin tools > > available in Access 97? > > > > Thanks for help all the time. > > > > AA > > > > > > "Douglas J. Steele" wrote: > > > >> Depending on what you're doing with the data, you may see slower > >> performance. For example, if you're doing queries that join multiple > >> tables > >> together, with criteria, more data than's required may be sent to the > >> client > >> to resolve the query. > >> > >> As to your second question, no import of data is required: you're working > >> with the actual tables in SQL Server. If you chose File | Get External > >> Data > >> | Import..., then you'd have to worrying about refreshing the data in > >> Access. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no e-mails, please!) > >> > >> > >> "Prince" <(E-Mail Removed)> wrote in message > >> news:C5E64442-700A-495F-B70B-(E-Mail Removed)... > >> > Hi, > >> > > >> > Thanks for answer, I really appretiate your quick and useful reply it > >> > will > >> > help me alot. > >> > I also wants to know that: > >> > > >> > What would be the processing speed as compare to Access's own tables? > >> > > >> > Another Question(related to that link): > >> > > >> > Do we need to write a program to automatic import data from SQL server > >> > on > >> > daily basis on same time Or we have some builtin tools in access? > >> > > >> > Thanks agin for your help. > >> > > >> > Amir > >> > > >> > > >> > > >> > "Jeff Boyce" wrote: > >> > > >> >> Create a Data Source Name (DSN) using the ODBC driver for SQL-Server > >> >> (or > >> >> for > >> >> whatever SQL database you are using). Then use File | Get External > >> >> Data > >> >> | > >> >> Link ... and use the ODBC 'type' file to connect to the SQL database. > >> >> Pick > >> >> the DSN you created. > >> >> > >> >> NOTE: you will have to have permissions (user/password) to the SQL > >> >> database > >> >> to "see" the tables and views. > >> >> > >> >> -- > >> >> Regards > >> >> > >> >> Jeff Boyce > >> >> Microsoft Office/Access MVP > >> >> http://mvp.support.microsoft.com/ > >> >> > >> >> Microsoft IT Academy Program Mentor > >> >> http://microsoftitacademy.com/ > >> >> > >> >> Microsoft Registered Partner > >> >> https://partner.microsoft.com/ > >> >> > >> >> "Prince" <(E-Mail Removed)> wrote in message > >> >> news:CF08652A-C890-4E0B-AD07-(E-Mail Removed)... > >> >> > Hi All, > >> >> > > >> >> > Is there any way that we can directly link Access programs with SQL > >> >> > database?? Instead of using access database use SQL tables ?? > >> >> > > >> >> > thanks in advance > >> >> > > >> >> > AA > >> >> > > >> >> > > >> >> > >> >> > >> > >> > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
you shouldn't have to worry about this Access Linked Table garbage
learn SQL Server DTS; it is a great tool and keep your data in SQL Server; just use Access Data Projects; they are a great reliable platform. it is much easier to deal with than this client server MDB _CRAP_ hope that helps -Aaron On Mar 28, 8:03 am, "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote: > If your tables are linked, no refresh is required. > > If your tables are in Access and were created by importing the data from > your external source(s), then yes, you'll need to write a routine to refresh > the imported data on whatever schedule you want. Nothing is built into any > version of Access to do this for you. > > -- > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele > (no e-mails, please!) > > "Prince" <Pri...@discussions.microsoft.com> wrote in message > > news 7482F4E-0C96-44B6-B597-(E-Mail Removed)...> > > > > Thanks for early reply Jeff, > > I am clear about first one but my second question that > > "Do we need to write a program to automatic import data from SQL server on > > daily basis on same time Or we have some builtin tools in access" > > I am sorry it was not clear I didn't explain in detail, > > > It was not from SQL server, I need to import some data in 4 - 5 programs > > on > > daily basis which are linked by ODBC with history server(And I import data > > from ODBC to Access Database on daily basis). I want to make that process > > automatic, Do I need to write some routine OR we have some builtin tools > > available in Access 97? > > > Thanks for help all the time. > > > AA > > > "Douglas J. Steele" wrote: > > >> Depending on what you're doing with the data, you may see slower > >> performance. For example, if you're doing queries that join multiple > >> tables > >> together, with criteria, more data than's required may be sent to the > >> client > >> to resolve the query. > > >> As to your second question, no import of data is required: you're working > >> with the actual tables in SQL Server. If you chose File | Get External > >> Data > >> | Import..., then you'd have to worrying about refreshing the data in > >> Access. > > >> -- > >> Doug Steele, Microsoft Access MVP > >>http://I.Am/DougSteele > >> (no e-mails, please!) > > >> "Prince" <Pri...@discussions.microsoft.com> wrote in message > >>news:C5E64442-700A-495F-B70B-(E-Mail Removed)... > >> > Hi, > > >> > Thanks for answer, I really appretiate your quick and useful reply it > >> > will > >> > help me alot. > >> > I also wants to know that: > > >> > What would be the processing speed as compare to Access's own tables? > > >> > Another Question(related to that link): > > >> > Do we need to write a program to automatic import data from SQL server > >> > on > >> > daily basis on same time Or we have some builtin tools in access? > > >> > Thanks agin for your help. > > >> > Amir > > >> > "Jeff Boyce" wrote: > > >> >> Create a Data Source Name (DSN) using the ODBC driver for SQL-Server > >> >> (or > >> >> for > >> >> whatever SQL database you are using). Then use File | Get External > >> >> Data > >> >> | > >> >> Link ... and use the ODBC 'type' file to connect to the SQL database. > >> >> Pick > >> >> the DSN you created. > > >> >> NOTE: you will have to have permissions (user/password) to the SQL > >> >> database > >> >> to "see" the tables and views. > > >> >> -- > >> >> Regards > > >> >> Jeff Boyce > >> >> Microsoft Office/Access MVP > >> >>http://mvp.support.microsoft.com/ > > >> >> Microsoft IT Academy Program Mentor > >> >>http://microsoftitacademy.com/ > > >> >> Microsoft Registered Partner > >> >>https://partner.microsoft.com/ > > >> >> "Prince" <Pri...@discussions.microsoft.com> wrote in message > >> >>news:CF08652A-C890-4E0B-AD07-(E-Mail Removed)... > >> >> > Hi All, > > >> >> > Is there any way that we can directly link Access programs with SQL > >> >> > database?? Instead of using access database use SQL tables ?? > > >> >> > thanks in advance > > >> >> > AA- Hide quoted text - > > - Show quoted text - |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Restricting bandwidth in windows 2003 server using remote access and routing server | technical.chap@gmail.com | Microsoft Windows 2000 RAS Routing | 0 | 17th May 2006 05:47 PM |
| Re: hosting provider that supports ASP.Net and telnet/Terminal Server access to virtual server? | Lucas Tam | Microsoft ASP .NET | 1 | 19th Aug 2003 06:07 AM |
| what level of server access is required in order to view tables with Server Explorer? | Bennett Haselton | Microsoft Dot NET | 1 | 15th Jul 2003 08:25 PM |
| SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? | Tobin | Microsoft Outlook Contacts | 1 | 7th Jul 2003 12:57 AM |
| SQL Server 2000, Exchange, COM-Add in for Outlook XP; Dynamically link ACCESS xp & SQL SERVER??? | Tobin | Microsoft Outlook Discussion | 1 | 7th Jul 2003 12:57 AM |
