Did you try to setup an Access test database and use the code to link the table? It refreshes the link and you don't have to login to the SQL database next time you start the Access database.
Nils
I used the solution from: Microsoft Knowledge Base Article - Q159691, Procedure to Create Data Sources and Relink ODBC Tables
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q159691
Hope this is what you are looking for
Nils
PS.
I distribute the "Access frontend" to users...
I have a table that i would like to take the data from one record and use that data as Field Names in a new table.
The original table contains Field names from a Database on a UNIX server. So the first record is field names for table1 second record for table2 etc.
The tables vary in size so I...
Installed Windows XP on a test machine, I can log on to the netware server with the generic client that comes with W-XP. I can access files but can't start the NWAdmin. Is there a new client for W-XP, where can I get it. Can I use the client for NT or 2000?
Thank You
Nils
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.