How do I use an Access Template and modify for use with my design

Now that I have created multiple forms/Subforms, my client announces it likes the lay out of an Access template and would like me to use that.  Looking for simplest way to convert the Price Comparison template into my existing work or vice versus.  Every time I open the downloaded version I am unable to see how to set the design view, unable to modify the tables, forms, etc.


Karen SchaeferBI ANALYSTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
hold the SHIFT key while opening the db
Karen SchaeferBI ANALYSTAuthor Commented:
did that still everything seems locked down - all the icons in nav pane has lock on it.  I even tried to import but nothing shows up during import.
Jeffrey CoachmanMIS LiasonCommented:
Is this a "Microsoft" official template, ...or did a third party create his template?
I don't see this template listed on the MS Site for Access templates...?

As far as I can tell "Price Comparison" is a "Web" database, no design view is available.
The tip-of is the little globes by each object in the Navigation pane.

With Web databases there is no VBA, you would have to pretty much take only your table data and import it into this template.
But then you would probably have to redesign your tables drastically to "Fit" the templates requirements.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeffrey CoachmanMIS LiasonCommented:
From the main page, (the "Getting Started" tab) many of the support links were broken, I cant see how you would get support with this template...
Jeffrey CoachmanMIS LiasonCommented:

To be clear, I cannot confirm 100% that this is a web DB.
I do not have any exposure to web databases,
...I was under the impression that it would be clear from the template, that this was a web db.
This way an Access developers would know up front.

So I have to thank you for posting this Q, as now I have to be more aware of this when I evaluate templates.
Karen SchaeferBI ANALYSTAuthor Commented:
Jeff that is correct - from what I can tell Web Database design prevents vba coding and that sucks.  thanks again for your input.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.