Flet i word fra SQL2000

Well you already have it working in Access97, so why dont you use this. Just replace the Access97 tables with the tables in your SQL Server. You link these table into Access via a DSN (ODBC Data Source).
This MUST be the easiest solution!

Inde fra Visual Basic editoren i Word kan man connecte til SQL\'en!

terry >> Meget intresant, men hvordan linker jeg tabelen i ODBC Data Source,  Kan du skære det ud i pap.

You first need to create an ODBC data source.

Settings+Control Panel+ODBC Data Sources.
System DSN + Add and then choose SQL Server.
Then you just follow the guide.
You obviously need to have your SQL Server security set so that you can log on.

Then once you have a DSN you go to the files+get external data+link tables menu.
Then in the Files of type list choose ODBC Databases() (at the bottom of the list).
Then find the Data Source you just created, choose the tables and thats about it.

Ja, det virker bare, jeg var halv vejs.  Lige til sidst hvis sql dataerne bliver ændret så er de også ændret i Accessen97 det vil sige er det
liveconnection

YES!

Takker

selv tak!