467,211 Members | 1,201 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 developers. It's quick & easy.

Linking linked SQL tables to back-end

Some time ago I am sure I came across something that said this was possible,
though it doesn't seem to work.

A client wants to replace an Access back-end with SQL Server tables. We have
tried linking the SQL tables to an Access back-end and then linking the
linked tables in the Access back-end to the Access front-end. Doesn't work
at all.

Obviously, this can't be done. What is the best way to replace an Access
back-end with SQL tables?

Do I have to change the front-end to use ODBC linked tables directly to the
SQL server?

Jeff

Nov 12 '05 #1
  • viewed: 4200
Share:
2 Replies
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:Ik*****************@news.optus.net.au...
Some time ago I am sure I came across something that said this was possible, though it doesn't seem to work.

A client wants to replace an Access back-end with SQL Server tables. We have tried linking the SQL tables to an Access back-end and then linking the
linked tables in the Access back-end to the Access front-end. Doesn't work at all.

Obviously, this can't be done. What is the best way to replace an Access
back-end with SQL tables?

Do I have to change the front-end to use ODBC linked tables directly to the SQL server?


Yep. There will then be *no* Access back end. The SQL Server becomes the
back end.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2
If you don't want to use ODBC linked tables, the create an Access ADP
project, which uses OLEDB connections to SQL. You also get a little more
native support for SQL Server in an ADP file vs. an MDB file. The upsizing
wizard built into Access will do alot of this for you.

--
James Lankford
"Jeff Pritchard" <je************@asken.com.au> wrote in message
news:Ik*****************@news.optus.net.au...
Some time ago I am sure I came across something that said this was possible, though it doesn't seem to work.

A client wants to replace an Access back-end with SQL Server tables. We have tried linking the SQL tables to an Access back-end and then linking the
linked tables in the Access back-end to the Access front-end. Doesn't work
at all.

Obviously, this can't be done. What is the best way to replace an Access
back-end with SQL tables?

Do I have to change the front-end to use ODBC linked tables directly to the SQL server?

Jeff

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Konstantinos | last post: by
reply views Thread by ericellsworth@gmail.com | last post: by
11 posts views Thread by dskillingstad@gmail.com | last post: by
5 posts views Thread by news.microsoft.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.