By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Linking linked SQL tables to back-end

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
"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

P: n/a
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.