Convert Access web database template into a desktop database (1 Viewer)

sigma788

Registered User.
Local time
Today, 06:01
Joined
Dec 1, 2009
Messages
40
is there any way of converting Access 2010 web database template into a desktop database.
i tried Northwind 2010 web database template 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.

Thanks.
 

AccessJunkie

Senior Managing Editor
Local time
Today, 06:01
Joined
May 11, 2006
Messages
278
Hi,

Yes it is possible to convert the 2010 Northwind Web Database into a client version. It will, however, take some 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 Northwind web database.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 

sigma788

Registered User.
Local time
Today, 06:01
Joined
Dec 1, 2009
Messages
40
Thanks for the reply
i have managed to convert forms/reports by saving individually as (saving as client object).
however i am stuck with converting Tables.
if i try by importing database the HIDDEN tables such as MSysRelationships,MSysQueries,MSysObjects etc gets renamed by suffix 1 and are different from original nortwind database.

i have attached my worked database deleting all records except one or two.

Thanks
 

Attachments

  • Nortwind 2010.zip
    654.6 KB · Views: 2,520

AccessJunkie

Senior Managing Editor
Local time
Today, 06:01
Joined
May 11, 2006
Messages
278
Hi,

When you import the web tables, you need to make sure you import them into a new client ACCDB container, not a web one. Otherwise, the tables remain web tables. Also, when you import tables, never import any of the system tables - the ones that start with the MSys prefix.

At any rate, attached is a completed client-only copy of the Northwind 2010 web database.

Hope it helps,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 

Attachments

  • Northwind2010Client.zip
    547.1 KB · Views: 4,023

sigma788

Registered User.
Local time
Today, 06:01
Joined
Dec 1, 2009
Messages
40
Thanks for helping me out.

i have another question
some MSys prefix tables (EXCEPT MSysRelationships) have different enteries. can they be ignored or can they create errors in future.

Thanks.
 

AccessJunkie

Senior Managing Editor
Local time
Today, 06:01
Joined
May 11, 2006
Messages
278
Hi,

The best advice I can give on that is to simply pretend those system tables are not there. They exist for Access to maintain various areas of your application but you should treat them as "hands off." Don't try and add, edit, delete, or modify in any way shape or form these tables - their structure or data. You could cause major damage to your application if you mess with them. Just ignore them. Change your Navigation Pane settings to hide the system tables (that's the default setting anyway) and you won't see them.

Don't be tempted by the Dark Side or forever will it dominate your destiny.

<Jedi hand waving>
These aren't the tables you're looking for...
</Jedi hand waving>

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 

sigma788

Registered User.
Local time
Today, 06:01
Joined
Dec 1, 2009
Messages
40
Thanks for the info.

Now we have functional Northwind 2010 client database template if anyone wants.

cheers..
 

Rich_Art

New member
Local time
Today, 14:01
Joined
Apr 2, 2012
Messages
2
Hi,
At any rate, attached is a completed client-only copy of the Northwind 2010 web database.

That is a fine local database but I have a problem with it.
When I click the "new purchase order" button I get an error warning which tells me "type mismatch" I can't find the problem which causes this error

error.jpg

Anybody experience the same error?? And what can I do about this.

Thanks in advance,

Peace,
Rich_Art. ;)
 

SDB

Registered User.
Local time
Today, 13:01
Joined
Sep 16, 2004
Messages
39
anyone got a 2007 version of this please. thanks
 

YNWA

Registered User.
Local time
Today, 13:01
Joined
Jun 2, 2009
Messages
905
Sorry for dragging up old threads but got a question.

Whats the problem with using the Web Database on a Client Desktop?
 

NKO

New member
Local time
Today, 06:01
Joined
Jun 30, 2013
Messages
1
This thread helped me a lot. I couldn't download the 2010 "Desktop Services Template" via Microsoft Access (returned 'corrupt', "not a template" and OLE errors) and the internet only had the web version. Took me a couple of hours but I converted it. If interested in the file, please PM me. I don't have a host site to upload it to.
 

D3XX

New member
Local time
Today, 06:01
Joined
Aug 8, 2013
Messages
1
NKO, there seems to be no way to PM you... I really want a blank client copy of "desktop services template"
 

NDD

Registered User.
Local time
Today, 08:01
Joined
May 8, 2012
Messages
100
I converted Issues Web Database template from 2010. I should be able to send it by email if somebody wants to put it up.
 

caddyboy

New member
Local time
Today, 09:01
Joined
Nov 10, 2013
Messages
2
NKO,

do you still have the converted client copy of the "desktop services template"? I could really use this. If you do please let me know!

Thanks in advance for your reply!
 

xpedite

New member
Local time
Today, 14:01
Joined
Nov 16, 2011
Messages
4
I converted Issues Web Database template from 2010. I should be able to send it by email if somebody wants to put it up.

I am interested in the converted Issues Database :)
Can you send me a copy please?


Thanks
Kristof
 

AccessJunkie

Senior Managing Editor
Local time
Today, 06:01
Joined
May 11, 2006
Messages
278
Hi,

Since it seems several people have asked about it, I made a client-only copy of the Issues 2010 style web database. It is attached to this post as a Zip file so anyone can grab it from here.

Hope you find it useful.

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
Senior SDET - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2013 Inside Out
Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010/2013 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------
 

Attachments

  • IssuesDesktopDatabase.zip
    169.3 KB · Views: 1,069

Users who are viewing this thread

Top Bottom