SQL Server

[PJ]

I have Imported numerous tables from a SQL server in to a blank Access
database for historical purposes. When I import them they still have a link
to the SQL server. Is there a way to break the link?


Thanks in advance

 

[Jeff Boyce]

PJ

Access provides a way to Import, or to Link. If you Import, you get a copy
in Access. If you Link, you get, well, linked to the tables in SQL-Server.

You can delete the links and try Importing again...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jeff Boyce]

By the way, if you SQL-Server is on your LAN, and if your LAN admin or
SQL-Server DBA is doing his/her job, that data is ALREADY backed up. Maybe
you could describe what you mean by "for historical purposes"...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[PJ]

Hi Jeff, Thanks. I did import the tables but I am still getting a right
arrow and a globe on each table. Does that not mean it is still linked to
the SQL server? This server is being retired and we no longer need a link to
it but wanted to keep a copy of the tables.

 

[Jeff Boyce]

I've seen that kind of behavior, but only when I try to "Import" from
another Access front-end, which is, itself, Linked.

Are you pointing directly to the SQL-Server via an ODBC driver, or are you
using an existing Access front-end that has linked tables?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[PJ]

I am pointing directly to the SQL-Server via an ODBC driver.

 

[Jeff Boyce]

Sorry, you've exhausted my experience.

Perhaps another reader has run across this.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.