Access with SQL Server

P

Prince

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
 
P

Prince

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
 
J

Jeff Boyce

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


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
D

Douglas J. Steele

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.
 
P

Prince

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
 
D

Douglas J. Steele

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.
 
P

Prince

Thank you so much for your help.

Douglas J. Steele said:
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.
Click to expand...
 
D

dbahooker

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
 
Top