Reply to thread

Message: [QUOTE="Pip''''n, post: 5602631"] I have a merge document that is located on a server that is accessed using a local company intranet. I have built my application to work on my local host and am now about to move it to the live server however I notice that the data source links in my database fields use access a data source link that is stored on my local machine. The database field reads: { IF { DATABASE \d "C:\\Documents and Settings\\username\\My Documents\\My Data Sources\\CompName MyIntranet mailMerge_Service.odc" \s "SELECT PATINDEX('%, 37,%', ', ' + ProductLookup + ',') FROM \"mailMerge_Service\"" \O#} ...... How do I rebuild the data source so that it doens't reference a connection that is stored on the host machine? The name of the data source in this case is "MyIntranet mailMerge_Service.odc". [/QUOTE]