Silmultaneous instances of MS Access 2K

Lauren Quantrell

I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq

Nov 12 '05 #1

Subscribe Post Reply

1491

Tom van Stiphout

On 5 Apr 2004 15:52:39 -0700, la*************@hotmail.com (Lauren
Quantrell) wrote:

254.
Note that the preferred configuration is with the ade on each
workstation.

-Tom.

I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq

Nov 12 '05 #2

david epsom dot com dot au

> open the same ade file residing on a server. Is there a limit and how

I don't think so (it's not like an mde or adp), but don't you get a
warning message for the second and subsequent users?

(david)

"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47*************************@posting.google.co m...

I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?
Thanks
lq

Nov 12 '05 #3

Tony Toews

la*************@hotmail.com (Lauren Quantrell) wrote:

I'm wondering how many different users on different workstations can
open the same ade file residing on a server. Is there a limit and how
would I trap any errors?

I recall reading some postings that there is some kind of limit at 20 users per
ade/adp. However this isn't a good idea anyhow. The following actually works for
any kind of file Access MDE/ADE, VB .exe, etc.

I specifically created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next time someone
went to run the app that it would pull in the latest version. For more info on the
errors or the Auto FE Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on each PC up
to date.

In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
a directory named after the user on a server. Given a choice put the FE on the
Citrix server to reduce network traffic and to avoid having to load objects over the
network which can be somewhat sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 12 '05 #4

Similar topics

cgi, classes and their instances

by: Klaus Neuner | last post by:

Hello, code (1) works, code (2) doesn't. (1) data = cgi.FieldStorage() comment = data.getvalue("comment") user_name = data.getvalue("user_name") (2)

Python

Instances of class object not modifiable?

by: Krzysztof Stachlewski | last post by:

I tried to run the following piece of code: Python 2.3.4 (#53, May 25 2004, 21:17:02) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> o = object() >>> o.a...

Python

Add Properties to Instances?

by: Martin Miller | last post by:

I'm trying to create some read-only instance specific properties, but the following attempt didn't work: > class Foobar(object): > pass > > foobar = Foobar() > foobar.x =...

Python

How can a Static member function know all instances?

by: SJ | last post by:

Hi: I have a class which has a static member function. The function implements something common to all instances. How can the static member function know all of the (Get access to the instances'...

C / C++

Configuring Multiple Instances DB2 WINNT

by: Mike | last post by:

Looking to find any information on how to properly configure multiple instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking for information on how the multiple instance settings...

DB2 Database

Silmultaneous instances of MS Access 2K

by: Lauren Quantrell | last post by:

I'm wondering how many different users on different workstations can open the same ade file residing on a server. Is there a limit and how would I trap any errors? Thanks lq

Microsoft Access / VBA

Web Controls/User Controls - Access Modifier

by: Mr Newbie | last post by:

I am messing around with Web User Controls at present and (think) I have discovered the following. 1.) The identifier for the control in the code behind must match the ID for the control on the...

ASP.NET

Data Access Application Block with C#

by: SAL | last post by:

Hi, I have Microsoft Enterprise Library 2005 installed on my local system. I'm developing in C# using Visual Studio 2003 IDE with framework 1.1. I am automating a process that will use a DLL...

C# / C Sharp

external access to instances

by: Ladislav Andel | last post by:

Hello, I have an application which is running in a loop(client/server app using twisted and reactor) and where are kept list of instances in memory. Each instance has it's own loop and it...

Python

Providing a no-overhead way for a contained class to access its container?

by: Peter Olcott | last post by:

So far the only way that I found to do this was by making a single global instance of the container class and providing access to the contained class, through this single global instance. Are...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++