<div>
Little bit confused about what you are trying to achieve. <br />
<br />
Would you mind spelling it out a bit clearer ? &nbsp;Not sure if you want to change Access, change Progress, Keep MS SQL and so forth. Maybe a &quot;psuedo code&quot; type example of a mapping as to how it is &quot;now&quot; and how you want it to be &quot;after&quot; and what the change is between &quot;now&quot; and &quot;after&quot; (e.g. upgrade MS SQL, or migrate to MS SQL etc).<br />
<br />
If you can, then it might be worth adding a couple of other zones to your question (I can do that for you).<br />
<br />

</div>


Little bit confused about what you are trying to achieve.

Would you mind spelling it out a bit clearer ?  Not sure if you want to change Access, change Progress, Keep MS SQL and so forth. Maybe a "psuedo code" type example of a mapping as to how it is "now" and how you want it to be "after" and what the change is between "now" and "after" (e.g. upgrade MS SQL, or migrate to MS SQL etc).

If you can, then it might be worth adding a couple of other zones to your question (I can do that for you).



<div>
Thanks for the response. I am trying to migrate access DB into SQL. But the access DB has linked tables to a progress database.<br />
<br />
How would i transfer the links for my access db to MSSQL so that my tables auto update every night from info in the progress db.
</div>


Thanks for the response. I am trying to migrate access DB into SQL. But the access DB has linked tables to a progress database.

How would i transfer the links for my access db to MSSQL so that my tables auto update every night from info in the progress db.

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I am trying to copy over my database links from MS access to MSSQL08. The links on access relate to DB links to a PROGRESS DB. I would like to keep the links on my MSSQL so that they update my MSSQL tables from the progress DB. <br />
<br />
How can i do this?
</div>
</div>


Hello

I am trying to copy over my database links from MS access to MSSQL08. The links on access relate to DB links to a PROGRESS DB. I would like to keep the links on my MSSQL so that they update my MSSQL tables from the progress DB. 

How can i do this?

access linked tables conversion to MSSQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.