Monday, May 26, 2014

convert the Web Database into a client version

manual work on your part.

Follow these steps:
- You first need to create a new empty client ACCDB file.
- Once that is open, you can import all the web tables, client forms, and client reports from the web copy into the client file. The web tables will be converted into client tables but you cannot import web queries, web forms, web reports, and web macros into the client version.
- Close the client copy now and open the web copy
- You can individually change a web object and save out a copy of the object as a client object.
- To do this, highlight a web query for example in the Navigation Pane. Click File tab, then Save & Publish area on the left, then Save Object As in the middle of this pane, and finally click the Save As Client Object button on the right side. You'll be prompted to give a name for the client object. Since it can't be the same name as the original at the moment, just use the same name and append the word Client at the end.
- You'll see a client copy of that web query in the Navigation Pane. To make sure the application still works, you'll need to delete that web query, and rename the client version to match the original name (remove the appended Client word from the name you gave it earlier.)
- You will need to repeat these steps for each and every web query, web form, web report, and web macro in the application. Yes, it will take some time to do that.
- Once complete, you can import all of these remaining client objects into your client only ACCDB file. Your file should now only have client copies of the  web database.

No comments:

Post a Comment

人生,只是一个过程。
Life Is a process.

相爱,是接受。接受,是爱的其一表现。
To love,is to accept. Acceptance is a form of love.
生活;就是将生与死,连接的一条线
Between live and death, there is a line connecting them both, which is call Life
思想决定行动,行动决定习惯,习惯决定品德,品德决定命运。
sow a thought, reap an action;sow an action, reap a habit;sow a habit, reap a character; sow a character, reap a destiny.
相信,就会还有。
不相信, 就连有得都变没有。.
希望。。在人间!
"事情是这样,就不会是别样“。。
很多事情,因为某些障碍,我表达和反应不来,但我真得很用心去想和做。。。

Thanks for visiting!