distributing Access - Microsoft Access / VBA

Mark Carlyle via AccessMonster.com

I have an access application that I want to roll out to my sales force. I
have a licenced version on access 2003 and the reps do not have the Access
program. How can I distribute the application So that they can run it.

I do have a .net server and all the reps are on its domain, but I would like
to run the program though maybe a runtime or exe or something so I dont have
to buy 50 copies of access.

TIA for the help
--
Message posted via http://www.accessmonster.com

Nov 13 '05 #1

Subscribe Reply

1394

Larry Linson

Will the sales force always be connected by LAN to your server? That would
be the simplest approach... split the database into a front-end (queries,
forms, reports, macros, modules, and perhaps local lookup tables) and a
back-end (tables, relationships, and data). Give each user a copy of the
front end, and link the tables in the back end.

You can use the Access runtime that comes as part of Visual Studio Tools for
Office. There's a Packaging and Distribution Wizard included in that, and it
costs about as much as one copy of Office Pro, if I recall.

If your sales force is always connected by a slow WAN or the Internet,
and/or sometimes not connected at all, then you have a more difficult task.
If you'll clarify, perhaps someone can make a more concrete suggestion.

Larry Linson
Microsoft Access MVP

"Mark Carlyle via AccessMonster.c om" <fo***@AccessMo nster.com> wrote in
message news:52******** ***@AccessMonst er.com...

I have an access application that I want to roll out to my sales force. I
have a licenced version on access 2003 and the reps do not have the Access
program. How can I distribute the application So that they can run it.

I do have a .net server and all the reps are on its domain, but I would
like
to run the program though maybe a runtime or exe or something so I dont
have
to buy 50 copies of access.

TIA for the help
--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

Similar topics

2129

Distributing Python programs

by: NEWS | last post by:

Can I install Python on a networked server and have any user run Python programs without having to go through the 9Mb client install? What are my options for distributing Python programs to my users? Thankyou to anyone who can help. Graham

Python

1950

distributing MySQL

by: Ian Davies | last post by:

Hello Recently changed from using Access to MySQL. Looked at the online docs but could not find anything about the process of distributing a database to customers. Can anyone give me a general idea of what is required. I sort of did a test by simply moving the database files to a different directory but was unable to connect after that through my VB front end. Also If anyone could point me in direction of links that show how to do...

MySQL Database

7427

Distributing Access Applications

by: John Phelan | last post by:

I read an article by, by Mike Groh, in Access-VB-SQL Advisor Magazine, Week 37 that concerns me quite a bit on distributing Access Applications commercially. First I need to describe a "commercial version" of my application that I hope to distribute after completing all the beta testing: A. It was developed using MS AccessXP Pro (developers edition), B. It has a front end MyApplication.mdb and a MyAppBbackend_be.mde; the front end is...

Microsoft Access / VBA

2431

Access 2000 Distributing

by: Scott | last post by:

Any help would be grateful :-) Problem: When I test my installation of Access 2000 MDE, I get the following error: "Unrecognised Format".. This means that Access 97 cannot read Access 2000. But I was under the Impression that Access 2000, could be redistributed using Install Shield 7 and that it would not effect the workstations current status. My Current senario is:

Microsoft Access / VBA

1744

Best way to handle distributing runtime installables from the web??? (slightly O.T.)

by: MLH | last post by:

I have little or no knowledge as to how a runtime Access database application might be distributed from a website. I am sure that I'm about to find out. I do have one question for you wizards though... My experience has shown that when I have installed applications from the web, my browser generally asks what I want to do with the file... Do I wanna save it? or Do I wanna run it? The browser generally warns about the dangers of executing...

Microsoft Access / VBA

1649

distributing access database files

by: mikemalin | last post by:

I've done some research on the net and think I have an answer, but I'm just looking for some other opinions. I would like to create an access database file to distribute to others. I would use an excel (which the other users would have) front-end to manipulate the database via vba. I'm assuming that since I'm only distributing the database file and not any part of the access program, there shouldn't be any type of legal issue. Any...

Microsoft Access / VBA

1796

avoiding reference problems when distributing apps

by: John Welch | last post by:

It happens much too often that I have to tell a client how to fix up missing references when I send them an application, especially if the client is distributing it to different users. It makes me look unprofessional (which I guess I am to some extent). I've tried the fixuprefs() function I got from the knowledge base (that uses the qryTestRefs and checks for error 3075), but it doesn't seem to get called, and I still get the problem. I'm...

Microsoft Access / VBA

1203

Distributing Application / SQL Server Express question

by: Michelle | last post by:

Hi I have an Access background and I wish to create a window application which will use a SQL connection for its data. I use VS 2005 Professional and know that the SQL Servicer Express edition is part of it. I'm used to distributing my applications split and putting the backend on the server. 1. How do I distribute SSExpress with my application? 2. Is it the same as installing on the client's server machine or does my

Visual Basic .NET

3396

Distributing the Access run-time - which version of VSTO?

by: Paul H | last post by:

Most of my projects are developed in Access 2003. I have not even installed Office 2007 yet! I need to buy VSTO to get the run-time licence for Access 2003. No doubt I will soon need a run-time licence for Access 2007. Is there a version of VSTO that has the Access run-time licence for both version of Access? Or will I need to buy VSTO 2003 now and then VSTO 2007 at a later date? Thanks,

Microsoft Access / VBA

1432

Access 2003: Distributing App

by: Umoja | last post by:

Hi Guys, I just complicated my database and I wanted to know what is the best practice for staff to access the APP. I have split my DB in 2. The back end stores the data and the front end is the App. The database will be placed on a network drive. In my DB I have 4 different forms, there are 4 different staff using the DB. Each have different task to do which is why I had to create different forms. The best way I thought for distributing the...

Microsoft Access / VBA

9511

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10408

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10139

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9983

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7529

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6768

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5417

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3697

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General