Different version of Access for frontend and backend.

Squirrel

I've developed an Access 2002 database which will be deployed with the
backend on
a server and frontend on the users' PCs. I've now been advised that new
employees will
be given laptops with Access 2003 installed and that the server software
will not be
updated. Also some of the users are using Access 2000 and some Access 2002.
My question is - will this work? There is a lack of IT support in this
department - they've
contracted with me to build a database - but I have no control over their
use of different
versions of Access. If it's going to be a complete mess it'd be great to
know that before
starting the install. I'd appreciate any advice anyone can offer as to what
I should expect.
Thank you.

Linda

Nov 12 '05 #1

Subscribe Reply

2810

Steve Jorgensen

On Mon, 2 Feb 2004 23:19:58 -0800, "Squirrel" <wi*****@covad. net> wrote:

I've developed an Access 2002 database which will be deployed with the
backend on
a server and frontend on the users' PCs. I've now been advised that new
employees will
be given laptops with Access 2003 installed and that the server software
will not be
updated. Also some of the users are using Access 2000 and some Access 2002.
My question is - will this work? There is a lack of IT support in this
department - they've
contracted with me to build a database - but I have no control over their
use of different
versions of Access. If it's going to be a complete mess it'd be great to
know that before
starting the install. I'd appreciate any advice anyone can offer as to what
I should expect.
Thank you.

Linda

1. It doesn't matter what version of Access is on the server or even if any
version is installed at all. The server is just hosting a shared file, and
it's the client machines that care what format it's in.

2. Access 2003 will handle Access 2000 format files just fine. You can leave
the front-end in Access 2000 format, or upgrade it as you prefer. In any
case, the links to back-end tables in Access 2000 will work fine.

Now, the only issue you might have is with the front-end, not the back-end.
Sometimes, code written with one version will only work on another version
after you unselect and reselect some references, and decompile. It's possible
you'll have to maintain at least 3 distributions of the front-end, one for the
Access 200, one for 2002, and one for 2003. You should do all development
work in the oldest version in use, so you know it doesn't rely on any newer
features not available in older versions.

That said, if you can strongly encourage them to dump Access 2000, my
experience is that reliability of VBA code will be improved. I don't have any
experience with 2003 to compare, but 2002 has proven basically stable.

Nov 12 '05 #2

Squirrel

Steve,

Thank you for responding to my question. I had assumed that Access had to
be installed on the server and that therefore there could be some conflict
between different versions on the server vs the users' PCs. But if it isn't
even necessary for Access to be running on the server then I can see why
there will be no conflict. And thx for the recommendations on Access
2000/2002 and maintaining different versions on the users' PCs.

Linda

"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:9b******** *************** *********@4ax.c om...

On Mon, 2 Feb 2004 23:19:58 -0800, "Squirrel" <wi*****@covad. net> wrote:
I've developed an Access 2002 database which will be deployed with the
backend on
a server and frontend on the users' PCs. I've now been advised that new
employees will
be given laptops with Access 2003 installed and that the server software
will not be
updated. Also some of the users are using Access 2000 and some Access 2002.My question is - will this work? There is a lack of IT support in this
department - they've
contracted with me to build a database - but I have no control over their
use of different
versions of Access. If it's going to be a complete mess it'd be great to
know that before
starting the install. I'd appreciate any advice anyone can offer as to whatI should expect.
Thank you.

Linda

1. It doesn't matter what version of Access is on the server or even if

any version is installed at all. The server is just hosting a shared file, and it's the client machines that care what format it's in.

2. Access 2003 will handle Access 2000 format files just fine. You can leave the front-end in Access 2000 format, or upgrade it as you prefer. In any
case, the links to back-end tables in Access 2000 will work fine.

Now, the only issue you might have is with the front-end, not the back-end. Sometimes, code written with one version will only work on another version
after you unselect and reselect some references, and decompile. It's possible you'll have to maintain at least 3 distributions of the front-end, one for the Access 200, one for 2002, and one for 2003. You should do all development
work in the oldest version in use, so you know it doesn't rely on any newer features not available in older versions.

That said, if you can strongly encourage them to dump Access 2000, my
experience is that reliability of VBA code will be improved. I don't have any experience with 2003 to compare, but 2002 has proven basically stable.

Nov 12 '05 #3

Tony Toews

"Squirrel" <wi*****@covad. net> wrote:

Thank you for responding to my question. I had assumed that Access had to
be installed on the server and that therefore there could be some conflict
between different versions on the server vs the users' PCs. But if it isn't
even necessary for Access to be running on the server then I can see why
there will be no conflict.

The most important thing though is to ensure everyone is at the same Jet 4.0 SP
version. Different versions could lead to corruptions.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the tips page at my website for more details including sample
code: Verify Appropriate Jet Service Pack is installed
www.granite.ab.ca\access\verifyjetsp.htm

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

Squirrel

Tony,

thx for your advice and the link to the code. I'll be sure everyone's
system is current before installing the database.

Linda
"Tony Toews" <tt****@teluspl anet.net> wrote in message
news:gi******** *************** *********@4ax.c om...

"Squirrel" <wi*****@covad. net> wrote:
Thank you for responding to my question. I had assumed that Access had tobe installed on the server and that therefore there could be some conflictbetween different versions on the server vs the users' PCs. But if it isn'teven necessary for Access to be running on the server then I can see why
there will be no conflict.
The most important thing though is to ensure everyone is at the same Jet

4.0 SP version. Different versions could lead to corruptions.

What I've done is use the various API calls available and am checking the version number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have on my system. See the tips page at my website for more details including sample code: Verify Appropriate Jet Service Pack is installed
www.granite.ab.ca\access\verifyjetsp.htm

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 #5

Similar topics

2533

one frontend different type of backends

by: w | last post by:

Hello all!!! For a year and a half now, we have been developing different Access 2000 applications. Most of them are access frontend and access backends. Some of them have SQL server 2000 as a backend. There is one application, which consists of a frontend and 3 backend mdb's. Different companies (80) are using the application: 1. Companies with just one pc and one user. 2. Companies with a Cytrix environment.

Microsoft SQL Server

2350

frontend / backend access question

by: matt bourke | last post by:

Hi, Can you please tell me what the advantage is of using an access backend with a VB frontend OVER access as a frontend and backend. M

Microsoft Access / VBA

1722

disconnect different frontends from backend

by: bl181076 | last post by:

Hello, In our organization we have 4 different access applications (all owned by different people) which use the same backend (owned by me). When the backend gets corrupt I have to disconnect everybody in order to be able to repair it. In my frontend application I use the timer event to disconnect all users from the backend. But as I have no permissions on the other frontends I cannot use that code there too. So, is there any way I can...

Microsoft Access / VBA

5644

SQL Backend/Access Frontend

by: PC Datasheet | last post by:

I have zero experience with using a SQL database for a backend and Access for a frontend. I have some questions: 1. Does an SQL database have tables? 2. How does Access connect to the data in an SQL database? Linking, importing, or ??? 3. Earlier today there was a thread regarding DAO and ADO. In the thread it was said that ADO is very useful when the backend is a SQL database. Could someone explain that?

Microsoft Access / VBA

1470

Networking Access

by: Gary | last post by:

I have the backend database on a network drive. There are 3 employees that access this backend database through their respective frontend databases (located on their respective C drive). One of these employees has a laptop. Q1. The laptop provides a problem in that each time it is connected to the network, he cannot access the backend. The database window still has the linked tables. The only remedy is to simply deleted the linked tables...

Microsoft Access / VBA

1988

Different backends

by: John | last post by:

Hi I have a single front end to which I would like to select one of two backbends at start-up. How can I accomplish this via code? Also is it possible to leave the "active" backend to last used at next start-up unless user wants to change? Thanks Regards

Microsoft Access / VBA

1968

Terminal Server or runtime version?

by: Paul H | last post by:

I have been approached by a new customer to "sort-out" their existing database. They occasionally need to remotely access the database and are using Terminal Server to do so. The weird thing is that all of the local users are using TS as well to save on Access licences! Two questions: If 20 people use TS to access a database do you need an Access licence for each user?

Microsoft Access / VBA

2340

Relative table link to a different directory

by: Matt | last post by:

Hi All, I have found a version of my answer on GG, but I have not been able to find my exact answer, thus the post. I am using Access 2000 Situation: I have a multi user frontend database located at 'O:\FE.MDB'. This database contains tables linked to the backend 'M:\BE.MDB' (names have

Microsoft Access / VBA

3738

Access Application For adding/editting SQL Records

by: Steve | last post by:

I have zero experience with ODBC. If I have an Access frontend connected to a SQL Database using ODBC, are the tables connected like a frontend/backend Access database where the the tables you see in the frontend are only "copies" of the tables in the backend? Or ar the tables "real" tables connected to the SQL tables in some manner? If the latter, can an Access table have more fields than the SQL table it is linked to? The reason for my...

Microsoft Access / VBA

8946

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8774

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

9447

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++

9181

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

6735

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

6031

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

4550

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

3261

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

2180

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