HELP, PLEASE! Unlink a table

[Nona]

I have a new database ready for the network that I split using the wizard.
One of the tables in this db was copied from another db and now refuses to
recognize the new BE in spite of repeatedly going through the automatic
Linked Table Manager. I get an error message saying it can't find this table.

How do I unlink this table? I read a previous question/answer that suggested
deleting the table from the secondary db, but I didn't really understand
this. What is the secondary db?

Many thanks for your help!

 

[a a r o n _ k e m p f]

it sounds to me like you need to get rid of linking entirely--
I think that linking is too complex for most developers of MS Access.

I moved to SQL Server and Access Data Projects about a decade ago--
because I saw that 'all databases automagically link- like they
should- when they are on the same server'

because a single db server fills the needs of 99% of the developers in
this group-- it makes a lot of sense to me-- to just move to SQL
Server

 

[Wayne-I-M]

Sorry - forgot to say - also have a look at the good advice given John Vinson
in the same thread (use the link gave in my answer above)

 

[Pete D.]

First backup everything. Then delete the linked table under the tables tab
in Access. Then close everything. Open access and relink your tables using
the wizard. Should cure your problem.
Pete D.

 

[Nona]

Thanks for your prompt replies! I'll work on this and will let you know!

 

[Troll Chaser]

Wrong again!

So you're saying that ODBC connections and OLEDB connections can't break?
Not only can they break, but troubleshooting a broken DSN requires
rebuilding it, often multiple times.

The real answer is to simply delete the Access table link and relink it to
the new source. Simple and quicker than trying to resolve any SQL-Server
connection problem. Only a retard would suggest rewriting an entire database
to handle a simple linking problem. What a BOZO you are!

it sounds to me like you need to get rid of linking entirely--
I think that linking is too complex for most developers of MS Access.

I moved to SQL Server and Access Data Projects about a decade ago--
because I saw that 'all databases automagically link- like they
should- when they are on the same server'

because a single db server fills the needs of 99% of the developers in
this group-- it makes a lot of sense to me-- to just move to SQL
Server

 

[a a r o n _ k e m p f]

wtf _ARE_ you talking about?
SQL Server connections don't fail-- things 'just work'.

I only have a single connection-- FILE, CONNECTION, SERVERNAME +
DBNAME

I don't need to set the connection strings in 200 different places--
and more importantly; I don't have to use an obsolete DAL in order to
do it.

DAO wasn't included with Office or WIndows for most of a decade.

Only a retard would use DAO for anything.

 

[Nona]

Got everything working beautifully! (without Aaron's help!)
Thanks very much! This is a wonderful service. Hope you all get paid well!

 

[Pete D.]

This is a group where many experts, and beginners donate free time to help
others in the newsgroup. Now that you know how to correct that problem come
back and teach others when your not busy. Just answer the questions for
others that you know. Glad you got it fixed.

 

[John W. Vinson/MVP]

Got everything working beautifully! (without Aaron's help!)
Thanks very much! This is a wonderful service. Hope you all get paid well!

Gratitude such as this is the only payment the volunteers here need or
expect. Thank YOU!

 

[Aaron Kempf knows nothing]

it sounds to me like you need to get rid of a a r o n entirely--

 

[Aaron Kempf knows nothing]

I a retard

 

[Wayne-I-M]

Gratitude such as this is the only payment the volunteers here need or

expect. Thank YOU!

Sorry John but I would like a cream cake

 

[John W. Vinson/MVP]

Sorry John but I would like a cream cake

<sending Wayne a virtual Ding-Dong, the closest approximation to this
delicacy available in Parma>

 

[a a r o n _ k e m p f]

Jet programmers average about half of what SQL developers / DBA make.

There's just not enough demand for high-level Jet developers.. anyone
that really cares about their data moves to SQL Server

-Aaron

 

[bcap]

Ignore Kempf, he is an idiot, a liar and a convicted criminal.