Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 26th, 2005, 06:04 PM
Authorized User
 
Join Date: Sep 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Matthew
Default installing an application over Network problem

Any one with a solution on how am I going to solve a network share problem. I have finished developed an Access application and Splitter the database, after compilered the application for installation and copy both the splitted copy and packaged file on a folder somewhere in a server as share the folder.

then I try to install the packaged fill on another computer over the network. It happened that after installation, the splitted table cannot be found by the installed program on the other compter.

Do you have an idea on how am I going to come around with this problem?

Any help will be appreciated.


Matthew Ikechukwu
Email: [email protected]
__________________
Matthew Ikechukwu
Email: [email protected]
 
Old November 28th, 2005, 01:53 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How does the front end reference the back end?

If the back end tables are linked to the front end, then you will need to make sure that new computer you are installing the front end on has the same drive mappings as the computer you developed the application on.

For example, if the front end is looking for the back end on

Z:\BackEndFolder\BackendFile.mdb

But the computer you are installing the front end on sees the same folder as

Y:\BackEndFolder\BackEndFile.mdb

Then, even though you can see the back end from the new computer, it isn't in the proper location.

Try remapping the same drive letter and folder structure on the new computer and it should work.

If the tables use a System DSN, then you just need to install or modify that.

Otherwise you may have to recode for the Provider and File location.

HTH

mmcdonal
 
Old November 29th, 2005, 03:29 AM
Authorized User
 
Join Date: Sep 2003
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Matthew
Default

I fix the problem like this
I create a folder on server and shared it sign appropriate right to the folder copy the Access file and splitter and save the back-end there. From there I package the application and install the packaged program to other computers. Very thing works fine.

Thanks for your time.


Quote:
quote:Originally posted by mmcdonal
 How does the front end reference the back end?

If the back end tables are linked to the front end, then you will need to make sure that new computer you are installing the front end on has the same drive mappings as the computer you developed the application on.

For example, if the front end is looking for the back end on

Z:\BackEndFolder\BackendFile.mdb

But the computer you are installing the front end on sees the same folder as

Y:\BackEndFolder\BackEndFile.mdb

Then, even though you can see the back end from the new computer, it isn't in the proper location.

Try remapping the same drive letter and folder structure on the new computer and it should work.

If the tables use a System DSN, then you just need to install or modify that.

Otherwise you may have to recode for the Provider and File location.

HTH

mmcdonal
Matthew Ikechukwu
Email: [email protected]





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem running Application on network hellian Apache Tomcat 1 June 7th, 2007 11:44 PM
Problem installing application on user machine 4x4 ADO.NET 2 March 2nd, 2007 09:14 AM
Creating a self installing application kevo Beginning PHP 2 January 29th, 2007 06:52 AM
Problem Facing while installing application rajib14 Crystal Reports 0 March 7th, 2005 04:07 AM
Installing an application in COM+ amantona VB Components 1 August 4th, 2004 11:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.