Link access tables to sql server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ranu - 21 Jul 2005 18:02 GMT

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.

Reply to this Message

Sylvain Lafontaine - 21 Jul 2005 19:28 GMT

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.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

> 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).
[quoted text clipped - 8 lines]
>
> Your help is highly appeciated.

Reply to this Message

aaron.kempf@gmail.com - 21 Jul 2005 19:31 GMT

you dont like jack sh.t 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

Reply to this Message

ranu - 21 Jul 2005 19:45 GMT

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

Reply to this Message

Sylvain Lafontaine - 21 Jul 2005 20:10 GMT

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.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC

> I am sorry. I think i have totally confused you guys.
>
[quoted text clipped - 17 lines]
>
> Ranu

Reply to this Message

aaron.kempf@gmail.com - 21 Jul 2005 20:41 GMT

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

Reply to this Message