473,756 Members | 1,808 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access 2003-2002 database connectivity

I am new to MS Access database and want to accomplish following. I have
a database and report in MS Access 2003. There are multiple users who
wants to access and generate their respective reports (self help).
Because of certain license restrictions they can not access 2003
installed on my PC.

We have a shared drive with 2002 installed on it. I wanted to
accomplish a connection between Access 2003 (my PC) and MS Access 2002
(shared drive). I wanted to have 10 mins data refresh in 2002. Finally
users will connect to 2002 and generate their report.

Please advice me on how to accomplish this. Any pointers, suggestions,
guidance will be really appreciated.

Thanks and Regards

Piyush

Sep 22 '06 #1
2 1638
same program minus the prettier menu bar icons in A2K3.

if you have multiple users accessing at the same time, i'd suggest you
look into a front-end, back-end setup. should be able to get the
details from the help file.

Sep 22 '06 #2
Read the following article of mine..it should help:

http://www.members.shaw.ca/AlbertKal...plit/index.htm

Note that you can run mixed clients. So, some can be access 2000, some can
be access 2002, and some can be 2003..

If you follow the above instructions, all 3 versions can use, and share that
data file...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
Sep 22 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3942
by: BT Openworld | last post by:
I have just had to upgrade to Access 2003 as Access 97 EMail (SendObject) doesn't work when loaded on Windows XP. I'm finding my way around Access 2003 but my biggest problem is getting information. When I bought Access 1.0 many years ago, I got a paper manual and an excellent help file with all you needed to know. With Access 97 the manual came as a 'Building Applications' document on the CD and I still had the excellent help. With Access...
1
522
by: pw | last post by:
Hi, I can't find anything about a toolkit on Microsoft site or what is needed to distribute an Access 2003 application (like the SDK w/ Access 97). I assume this is still possible. What do I need to create the setup files? -pw
2
4449
by: Johnny Meredith | last post by:
Hi all, I'm interested in getting the Access Developer's edition. Here's my question: where do I go to get it? At Microsoft, there's a Access 2003 Developer's Extensions package, as well as some other packages with mention the .Net framework. ($499 was the price tag on that, which was what I was expecting for the Developer's edition of Access.) Also, I have purchased a copy of Visual C# .Net Standard edition and I hope to
2
1777
by: Kelt | last post by:
I have a user who currently has Access 97 installed on her PC. She has purchased a new PC and would like to have Access installed on it. She would like to upgrade her current Access to Access 2003. When installing the Access 2003 upgrade on the new PC, do I have to install Access 97 first, then run the Access 2003 upgrade CD? And if so, do I need any unlocking or any type of codes during the Access 97 installation? Or can I just run...
0
1676
by: HelenD | last post by:
Last night took the plunge and upgraded to Office 2003 pro, and told it to get rid of 2000. Realized too late that some programs (such as FMS Develper Suite) do not yet include the components to work with 2003 version-single compnent ugrades are just too expensive. Speed Ferret has not yet released a new version to work with Access 2003. So I need to have Access 2000 back. Can someone please advise? Can I install only Access 2000 in a...
1
5166
by: Mike | last post by:
Hi Hi We are currently upgrading from access 97 to office 2003 on site. We would like to upgrade our access databases to Access 2003 but we wish to remove Microsoft access software from our end users so that we can control the creation of databases. Is there a way that our end users can still use these upgraded access databases without having access 2003 installed on their machines. The mdes will reside on a server so they can be...
3
2024
by: Richard W Collens | last post by:
Hey folks! Before I spend any money on Access 2003, is it co-habitable with Office XP? Also, can I use the XP Developers Edition to package and deploy and Access 2003 project? Thanks in advance! Rick
10
3051
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the Runtime? I just purchased Office 2003 Professional. Is Access 2003 Runtime included with that or not? It APPEARS that the only way I can get Access 2003 Runtime is to
5
1760
by: Ecohouse | last post by:
I'm using VB and an Access 2003. The db was originally created in Access 2000, but the computer had to have things reinstalled and now has Access 2003. So I was wondering if there are any compatibility issues using the two programs. I know that when using data controls you can select Access 2000 for the connect property. This VB program also uses DAO and not ADO. I've been having some weird things happen to the program since using
6
2793
by: Donald Grove | last post by:
I do programming in Access 2000 and 2003. I don't have a copy of 2003 myself, though. I have read about the adp software that comes with Access 2003, that converts an application to an access front end with a SQL server backend. It sounds like a good way for me to begin to learn about SQL server. I have thought about just shelling out the bucks for a copy of Access 2003, but the adp software is really the only reason. Do the folks
0
9456
marktang
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...
0
9872
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9843
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,...
0
9713
tracyyun
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...
0
8713
agi2029
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...
0
6534
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();...
0
5304
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3805
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
3
2666
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.