relinking tables using MS Access -- sql server odbc

AkAlan
10/25/2005 10:44:03 AM

I'm new to SQL and am in the process of migrating to a SQL backend for my
Access 2000 front end. I'm going the ODBC route to get my databases up and
running quickly and then move to an Access Project but I'm haveing problems
understanding the relinking issue. Is there a white paper I've missed on
programatically relinking the tables of a users front end when I make changes
to the table structure. I don't want to have to redistribute the front end

Sue Hoegemeier
10/26/2005 4:53:38 PM

You should link the tables programmatically when the user
starts the app. You'd use DAO and the TableDef object, set
it's properties, append it to the TableDefs collections.
That's about all I remember off the top of my head - I
thought the help file had an example. If you google for it
or post in one of the access newsgroups, you should be able
to find a detailed example.

-Sue

On Tue, 25 Oct 2005 10:44:03 -0700, AkAlan
[quoted text, click to view]

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 : relinking tables using MS Access