Problem creating distribution package

[ashu.doc]

Hello everyone


I am having problem in creating a distribution/deployment package for my db. I have created FE mdb and BE mdb files, when I am going through the package distribution wizard, in the second page, the first field it asks the file to package, which I am locating on my computers drive, suppose it is G:\data.mdb, and in third page it asks for additional file in which I have located G:\data be.mdb. So when I am installing this package to another computer, installation running fine, but it is giving error after opening the db - cannot locate G:\data.mdb.
My question is, shouldn't the package is suppose to include all the files which I have added during package, then why is it still asking for those files on the different computer?

many thanks

[rzw0wr]

I used the Publishing package maybe twice.
I tried many times. It will not let you do much and it is confusing to me.

I don't think it will allow you to make over 1 new folder.
The only place I could get the package to put the fe was under the Admin id.

I have been told that there are a few free packaging apps on line that work better.

Dale

[amrut]

The FE is linked to BE based on the path to BE on your computer. When it is installed on any other PC, the FE must be re-linked to the BE atleast once after installation. You can do it manually or through code.
Try this on your PC. Move the BE on your computer to another location or simply rename the BE. Now if you open the FE, you will get the same error message.

[ashu.doc]

So that means everytime I give this db to anyone he must link FE and BE? Or the simpler way may be not to break the db in two?

[amrut]

So that means everytime I give this db to anyone he must link FE and BE?

Yes

Or the simpler way may be not to break the db in two?

No, it is always a good practice is to split database. See http://www.techrepublic.com/blog/10t...-database/1119
Here is code for refreshing table links http://access.mvps.org/access/tables/tbl0009.htm