Link access tables to sql server

  • Thread starter Thread starter ranu via AccessMonster.com
  • Start date Start date
R

ranu via AccessMonster.com

I am a newbie here. I want to link access tables dynamically to sql server
tables (mind you, not sql tables to ms access tables).

I have access tables that are constantly inputed/updated by user inputs.
Hence, i want them to be linked and not imported. Once i link them to
existing sql tables then i do not have to worry about the data any more and
can write sp/views/functions. Can any one help me by providing step by step
process of linding access to sql tables .

Your help is highly appeciated.
 
This newsgroup is about ADP and not about MS Access ODBC Linked Tables to a
SQL-Server. You should ask your question in m.p.access or
m.p.access.externaldata .

Also, even with ODBC Linked Tables, I'm not sure about your statement « ...
not sql tables to ms access tables ». This statement is very confusing
about what you want.
 
you dont like jack shit to SQL Server; you just start up a new Access
file, Project (existign data) and then you dont have to deal with any
of that crap.

it just keeps all the queries on the db side where they belong.

-aaron
 
I am sorry. I think i have totally confused you guys.

First of all, I am working on ADP where my front end is access and backend/db
is SQL.

Secondly, we have a mortgage software called byte (External software). Our
users get on to byte and enter whole lot of information. That information
gets stored in access database.

We have lot of reports, queries/views/sp out of this database that is linked
to our local MS Access database. Now that we are upgrading to ADP, i want to
know how to link the data(ms access tables) out of the byte to sql.

Hope i made sense.

Thanks again

Ranu
 
No easy way to do this: the ADP is linked to a SQL-Server and has no local
tables. The easiest way would be to use ADO (or DAO) to open the MDB tables
and import everything you need in the SQL-Server.

From SQL-Server, you can also link MDB files as external databases but here
again, I'm not sure if this will make any good to you.

Finally, you can use replication to automatically synchronise a mdb file
with the SQL-Server when a user attach his machine on the LAN but it's not
an easy task to configure. You can find many articles on this topic on the
internet by searching the words « replication access sql-server ».

If you users are always connected to the internet, the easiest way would be
to forget about the mdb local databases.
 
you can link the server; instead of linking the client.

this app you're trying to link to; if it is in SQL Server already; it
is easy to setup the link between these 2 database servers.

if they're on the same sql server; it is even EASIER.

-aaron
 
Back
Top