Linking linked SQL tables to back-end

[Jeff Pritchard]

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

[Rick Brandt]

"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

[James Lankford]

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