A2K3 on Windows Terminal Server - Microsoft Access / VBA

David W. Fenton

I'm setting up a project for a client on a new Windows Terminal
Server. The application is currently in A2K, but the sysadmin does
not want to install that, he wants to install A2K3, because Office
2K3 is the organization's new standard (they want to be fully
converted within the new calendar year).

What issues will I have, if any, with A2K3 on WTS? Anything
different from A2K? Anything not specific to WTS that I need to know
about A2K3, which I've never used, ever?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #1

Subscribe Reply

2462

Tom van Stiphout

On Wed, 29 Dec 2004 22:53:45 GMT, "David W. Fenton"
<dX********@bwa y.net.invalid> wrote:

So far I am impressed with the Access 2000 compatibility mode in
Access 2003.

-Tom.

I'm setting up a project for a client on a new Windows Terminal
Server. The application is currently in A2K, but the sysadmin does
not want to install that, he wants to install A2K3, because Office
2K3 is the organization's new standard (they want to be fully
converted within the new calendar year).

What issues will I have, if any, with A2K3 on WTS? Anything
different from A2K? Anything not specific to WTS that I need to know
about A2K3, which I've never used, ever?

Nov 13 '05 #2

pks

David W. Fenton wrote:

I'm setting up a project for a client on a new Windows Terminal
Server. The application is currently in A2K, but the sysadmin does
not want to install that, he wants to install A2K3, because Office
2K3 is the organization's new standard (they want to be fully
converted within the new calendar year).

What issues will I have, if any, with A2K3 on WTS? Anything
different from A2K? Anything not specific to WTS that I need to know
about A2K3, which I've never used, ever?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

David,

I've had great success with that particular setup. I develop in A2K,
but one client in particular has been running an A2K FE/A2K BE using
A2K3 on WTS and haven't come across any major problems in over 2 years.
Well, except that I keep forgetting the workgroup administrator is
accessed via Tools|Security and not from a separate program. I like
the fact that A2K3 opens an A2K db and allows new queries, reports,
etc. without having to convert the db.

I have had to make table changes over time via VBA (adding tables with
appropriate security, adding fields, modifying fields) and haven't run
into any issues there once it passed testing on my A2K development
machine. All coding currently in my application has worked fine. BTW,
I still use DAO rather than ADO.

There is still the rare crash/corruption, but that has dropped
dramatically since I convinced them to put the BE on the TServer as
well as the FE. (That was due to intermittent network hiccups that
they never fully resolved, but they only seemed to affect Access
databases.) And when A2K3 does a repair, it makes a copy prior to
running the repair. A nice feature, but I had already learned the hard
way to always make a backup first. (Thanks, Peter Miller.)

I haven't found a case for A2K3 over A2K in my situation, but at least
they work and play very well together.

Nov 13 '05 #3

David W. Fenton

Tom van Stiphout <no************ *@cox.net> wrote in
news:of******** *************** *********@4ax.c om:

So far I am impressed with the Access 2000 compatibility mode in
Access 2003.

What does that mean?

Can I set it from code?

Can I configure the WTS users to run in A2K compatibility mode
without logging on as each one?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #4

Tom van Stiphout

On Thu, 30 Dec 2004 22:55:30 GMT, "David W. Fenton"
<dX********@bwa y.net.invalid> wrote:

What I meant was, that running an Access2000 application in Access2003
is entirely seamless. No need to set anything. Just really good
backward compatibility from your friends at MSFT.

-Tom.

Tom van Stiphout <no************ *@cox.net> wrote in
news:of******* *************** **********@4ax. com:
So far I am impressed with the Access 2000 compatibility mode in
Access 2003.

What does that mean?

Can I set it from code?

Can I configure the WTS users to run in A2K compatibility mode
without logging on as each one?

Nov 13 '05 #5

David W. Fenton

Tom van Stiphout <no************ *@cox.net> wrote in
news:q4******** *************** *********@4ax.c om:

What I meant was, that running an Access2000 application in
Access2003 is entirely seamless. No need to set anything. Just
really good backward compatibility from your friends at MSFT.

What about the code signing thing? Don't you have to turn something
off in Access to get it to stop nagging you about unsafe code
execution?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #6

Trevor Best

David W. Fenton wrote:

Tom van Stiphout <no************ *@cox.net> wrote in
news:q4******** *************** *********@4ax.c om:

What I meant was, that running an Access2000 application in
Access2003 is entirely seamless. No need to set anything. Just
really good backward compatibility from your friends at MSFT.

What about the code signing thing? Don't you have to turn something
off in Access to get it to stop nagging you about unsafe code
execution?

Set Macro Security to Low, just like in Word/Excel.

--
This sig left intentionally blank

Nov 13 '05 #7

David W. Fenton

Trevor Best <no****@besty.o rg.uk> wrote in
news:41******** *************** @news.zen.co.uk :

David W. Fenton wrote:
Tom van Stiphout <no************ *@cox.net> wrote in
news:q4******** *************** *********@4ax.c om:

What I meant was, that running an Access2000 application in
Access2003 is entirely seamless. No need to set anything. Just
really good backward compatibility from your friends at MSFT.

What about the code signing thing? Don't you have to turn
something off in Access to get it to stop nagging you about
unsafe code execution?

Set Macro Security to Low, just like in Word/Excel.

Where? Can it be done in code? Can the base installation of Access
be configured this way so that all users inherit that setting when
they log on for the first time?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #8

Darryl Kerkeslager

I've been following this thread, and was going to ask the same question, but
then I thought ... "Now how secure would that be if you could turn off the
security that prevents you running the database (without a message) from the
database?" ... ;)

Darryl Kerkeslager
"David W. Fenton" <dX********@bwa y.net.invalid> wrote:

Tom van Stiphout <no************ *@cox.net> wrote:

Set Macro Security to Low, just like in Word/Excel.

Where? Can it be done in code? Can the base installation of Access
be configured this way so that all users inherit that setting when
they log on for the first time?

Nov 13 '05 #9

Trevor Best

David W. Fenton wrote:

Set Macro Security to Low, just like in Word/Excel.

Where? Can it be done in code? Can the base installation of Access
be configured this way so that all users inherit that setting when
they log on for the first time?

I've not tried, I've not looked at 2003 in depth yet.
--
This sig left intentionally blank

Nov 13 '05 #10

Similar topics

1790

A GUI toolkit for Python that is NOT x-windows dependent

by: Andre Brightway | last post by:

I need a script to draw a keyboard to the screen and animate the marking each key when the key is pressed (among other things like being able to draw menus). This script is for testing keyboards and needs to be run by people who may never have touched a computer before so it needs to have an easy to follow GUI interface. But the Linux boxes these will be runned on are very low-end, 'diskless' terminals where running a full X-Windows...

Python

2487

.Net application running in Windows 2000 Terminal Server

by: Chung Ley | last post by:

Hi I am having problem running an .net application on a Windows2000 Terminal Server. The application seems to work fine on user's desktop The issues that I have with running the application on the Terminal Server are 1. When exiting the application, I got the following error dialog box Title: .Net-BroadcastEventWindow.1.0.5000.0.5:MyExecutable.exe - Application Erro Message: The instruction at "0x77f8910e" referenced memory at...

.NET Framework

2744

Writing Session Specific Code For Windows 2003 Terminal Server Session

by: OHM | last post by:

Hi peoples, I dont know where to place this question, so as I know you guys are all resourceful experts, I thought I would try here. I am writing some code which will be run usingh remote desktop ( On windows 2003 Server ), I need to determine in the code the machine name and username. If I use GetUsername and GetMachineName, it simply gives me the name of the currently logged on user ( at the Server ) and the Servers Machine Name.

Visual Basic .NET

1143

BUG: 8.0 beta1 does not run on Windows 2000 Terminal Server

by: Glen Parker | last post by:

8.0 beta1 does not run on Windows 2000 Terminal Server. This is the http://pgfoundry.org/projects/pginstaller/ download from 08/09/2004. It ran OK for me on Win2K Pro, so I suspect this is caused by the terminal server stuff; I have experienced differences in shared memory code between terminal server and non terminal server in the past. postmaster throws this error immediately. FATAL: could not create shared memory segment: No error

PostgreSQL Database

2375

User verification in windows forms

by: =?Utf-8?B?Sm9obiBBdXN0aW4=?= | last post by:

I have an app that prints entry tickets. If the printer driver is not set up exactly to detect the black mark on the back of the ticket, the tickets do not print correctly. Because of this, all users are logging on with the same user name to ensure they get a correctly configured printer driver. The application runs on a Terminal Server via the RDP client. In order to audit the actions of users, it is necessary to identify each user....

Visual Basic .NET

3774

CAL for Windows Server 2008 in a Terminal Server environment

by: =?Utf-8?B?QW50amU=?= | last post by:

I need product keys for Terminal Server Windows Server 2008 access (CALs) under MSDN - TSLM Service said they cannot provide product keys for the access.

.NET Framework

9228

Windows Autorun FAQs: Description

by: AmberJain | last post by:

Windows Autorun FAQs: Description NOTE- If you are unfamiliar with the concept of autoruns, then read "Windows Autorun FAQs: Overview". Que-1: How can I safely remove or edit the autorun settings on my PC? Ans: I recommend that you backup all of your important data before trying anything mentioned in this article. When a person is tweaking with autoruns, one has to rely on 'trial and error' methods and so there is always the possibility...

Microsoft Windows

30258

Windows Autorun FAQs: List of autostart locations

by: AmberJain | last post by:

Windows Autorun FAQs: List of autostart locations Linked from the Original article- "Windows Autorun FAQs: Description". Que: Can you list all the autostart locations for windows? Ans: Here is a comprehensive list of all autostart locations for Windows OSes: NOTE : These are some abbreviations used in this list. Please note them carefully: HKCU = HKEY_CURRENT_USER HKLM = HKEY_LOCAL_MACHINE

Microsoft Windows

9642

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

10524

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

9312

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7741

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

6948

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

5616

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

4409

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3956

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

3074

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