HI.
I have written an access 2007 database which looks at SAGE files, and produces custom reports from the SAGE data.
I need to distribute this database to several PC's at my clients site.
I can produce the deployment package using the wizard, which I have to say was really easy and worked without much fuss.
My question is, how do I tell the runtime database where the linked files are, it's likely to be different on different PC's as the SAGE file is on the server.
Is it possible to start the linked table manager from a button on a form, or do I need to write some code to do the table linking manually.
I do need to be able to input the file location on each PC independantly.
I have looked at the knowledges base on the microsoft site where it mentions packaging front and back ends seperately, but doesn't explain how to link them once they are on the clients PC.
Thanks in anticipation for you help.
Sue
I have written an access 2007 database which looks at SAGE files, and produces custom reports from the SAGE data.
I need to distribute this database to several PC's at my clients site.
I can produce the deployment package using the wizard, which I have to say was really easy and worked without much fuss.
My question is, how do I tell the runtime database where the linked files are, it's likely to be different on different PC's as the SAGE file is on the server.
Is it possible to start the linked table manager from a button on a form, or do I need to write some code to do the table linking manually.
I do need to be able to input the file location on each PC independantly.
I have looked at the knowledges base on the microsoft site where it mentions packaging front and back ends seperately, but doesn't explain how to link them once they are on the clients PC.
Thanks in anticipation for you help.
Sue
