Results 1 to 2 of 2
  1. #1
    tasjil is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    1

    converting Projects Web Database into a desktop database

    is there any way of converting Access 2010 web database template into a desktop database.


    i tried Projects Web Database and after converting into accdb the form and reports cannot be edited in design view( there is no design view option).
    such forms and reports cannot be exported also.
    http://templatescart.com/download/pr...tabase-61.html

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    is there any way of converting Access 2010 web database template into a desktop database.
    Yes, doable, but this is going to be a lot of work.

    You would need to export the table structures/data to a text file. (each table)
    You will need to open EACH query and write down the tables involved and the field in the query design grid. You will have to manually re-create them.
    For the forms and reports, you will need to open each in layout view, sketch what each form/report looks like.
    Where each control is located and the all of the properties of that control.... including but not limited to: control source, formatting, control name, and where in the form/report it is located). Some controls are combo boxes, so need row sources.

    For the tables "Tasks" and "Projects", you will need to look at the data macros. While the table is open, click on "Table" under "Table Tools", then click on each of the macros. Write down the macro steps. (I really hate macros - especially table data macros! ) You will need to recreate them or convert them to VBA code.


    Create a new accdb, import the table structures (from the text files). Looking at the data (if any), determine the field type required.
    Next, after the tables are created, create the queries.
    Forms can now be created. You must know how navigation forms work. (I never use navigation forms) You can click on things and see what the navigation targets are (or the embedded macros).


    Good luck with your project......

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-27-2016, 06:20 AM
  2. Replies: 1
    Last Post: 03-21-2015, 11:55 AM
  3. Replies: 6
    Last Post: 02-01-2015, 11:37 PM
  4. Emplyees and Projects database
    By Immortal in forum Access
    Replies: 1
    Last Post: 07-02-2014, 05:20 PM
  5. Replies: 4
    Last Post: 08-21-2013, 07:08 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums