Microsoft Access 2000 missing ODBC Links -- sql server odbc

Mary Chipman
10/22/2004 9:40:36 AM

That happens whenever you make a schema change to the table in SQL
Server. One way to avoid these errors is to write VBA code that runs
on startup. It deletes any old links and re-creates them when the
Access app opens, guaranteeing that the links are always valid.

--Mary

On Fri, 22 Oct 2004 02:40:27 -0700, Umberto Tullo (tullo@tin.it)
[quoted text, click to view]

Mary Chipman
10/24/2004 4:08:28 PM

It might be a network error if you're not making any schema changes.
I'd still recommend creating a procedure to deletelink/relink tables.
This will save you from having to do it manually every time there's an
error and the connection gets dropped.

--Mary

On Fri, 22 Oct 2004 08:33:12 -0700, Umberto Tullo (tullo@tin.it)
[quoted text, click to view]

(tullo NO[at]SPAM tin.it)
10/25/2004 1:38:45 AM

Thanks for answering me !

I'll keep on trying.
Table relinking solution is OK but it's too slow...

Thanks anyway.

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/

Mary Chipman
10/25/2004 2:09:01 PM

It shouldn't be slow at all if you have a valid SQL Server connection
over a LAN. It should only take a couple of seconds for the code to
execute.

--Mary

On Mon, 25 Oct 2004 01:38:45 -0700, Umberto Tullo (tullo@tin.it)
[quoted text, click to view]

(tullo NO[at]SPAM tin.it)
10/26/2004 6:41:18 AM

Relinking one or two tables is OK, but I have 110 tables linked :-O !

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/

Mary Chipman
10/26/2004 10:01:19 AM

I'm not talking about doing it manually, I'm talking about running VBA
code that uses DAO to delete and recreate tabledef objects. This
should run very quickly since all it's doing is creating tabledef
objects in the local .mdb and setting their connection properties. You
don't access the actual tables on the server until you open them. The
only way this code takes longer than a few seconds is if you're
linking thousands of tables, which no one in their right mind is going
to do anyway.

--Mary

On Tue, 26 Oct 2004 06:41:18 -0700, Umberto Tullo (tullo@tin.it)
[quoted text, click to view]

Ron Hinds
10/27/2004 1:39:37 PM

You shouldn't need to delete and recreate the TableDef objects Umberto. Just
call the RefreshLink method. Mary is correct it should go very fast -
seconds not minutes. Use this code:

For Each tdf In CurrentDb.TableDefs
If InStr(1, tdf.Connect, "ODBC") > 0 Then
tdf.RefreshLink
End If
Next

[quoted text, click to view]

Ed21
11/2/2004 1:40:15 PM

I have been having the same trouble lately, but I think I just fixed it
When linking the table there is a check box to save password (I swear
have never seen it before). I reestablished one table from eac
database I am linked to and it seems to work. Previously every time
closed and reopened Access I had to relink the tables

-
Ed2
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message443464.htm

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Microsoft Access 2000 missing ODBC Links