473,657 Members | 2,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ReConnecting Front and Backend

Thank you for any and all assistance. I'm trying to build a small application.
On my computer the front and backend work great, until I change the name of the
original files to something else, or install it on a computer without MS
Access. Then the link is broken...HELP!

Is there a way to keep the link there, or relink the two databases?

Michael
Nov 12 '05 #1
2 2397
lu************* @aol.com (Lumpierbritche s) wrote in message news:<20******* *************** *****@mb-m29.aol.com>...
Thank you for any and all assistance. I'm trying to build a small application.
On my computer the front and backend work great, until I change the name of the
original files to something else, or install it on a computer without MS
Access. Then the link is broken...HELP!

Is there a way to keep the link there, or relink the two databases?

Michael


From the front end select Tools, Database Utilities, Linked Table
Manager. Hit "Select All" and check the "Allways Prompt for New
Location" checkbox and click <OK>, locate your BackEnd .mdb file and
you should be good to go...

If you don't have Access installed on the target PC you'll need the
Developer edition of Access to get a license for the Runtime files
that you can then deliver to the client royalty-free.
Nov 12 '05 #2
I have the developer edition of 97, 2000 and 2002, but the only one I can get
to work is the 97. Is there another file, other than the Access and Workstation
file runtimes I need to connect the front and backends?

Michael
Nov 12 '05 #3

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

Similar topics

6
2468
by: Ian Baker | last post by:
We have been developing in MS Access/VBA for nearly 10 years now and find we need to get with the times and look at a web type of front end to a more robust/multi user back end. I would be interested to here any thoughts on which way we should go. We currently have an IT Help Desk application that we need to duplicate in new technology (example at http:jackaroo.net.au) which needs to be able to have many users eg Corp wide and to handle...
1
2021
by: Lumpierbritches | last post by:
I'm developing a small program that I would like to have a front and backend, so when I change the forms, all I have to do is upload the file on the frontend and if I change the tables, I can append the data. The problem I'm having is when I break the db, the front and backend go flawless. When I package and place in the P&D Wizard, I place both in with the Runtime and Workgroup along with relevant icons. When I install it on a foreign...
5
324
by: Lumpierbritches | last post by:
Thank you for your assistance in advance. I'm trying to figure out why on my computer the front and back ends are ok, when I use Access developer and set up the program with the front and back ends in the same install folder, I get errors and no way to reconnect the front and back end on the foreign computer. Is there something in the developer package that allows this to happen, that I'm not loading with the program and setup files? ...
2
341
by: Lumpierbritches | last post by:
Thank you for any and all assistance. I'm trying to build a small application. On my computer the front and backend work great, until I change the name of the original files to something else, or install it on a computer without MS Access. Then the link is broken...HELP! Is there a way to keep the link there, or relink the two databases? Michael
7
2471
by: JMCN | last post by:
Is this possible to have the 97 users with 97 front end, 2000 users with 2000 front end, 2002 users with 2002 front end, and 2003 users with 2003 front end all linked up to an access 97 backend? We are currently planning on upgrading workstations with either 2000, 2002, 2003. the criteria for the specific version will depend on the IT department. I would like to know if we have several different office versions will it work to have...
2
3138
by: Peter | last post by:
(I've tried this Q in the ms forums without response. See how it goes here.) Using A2003 but I guess this is not version-specific... If I want to implement row/record level locking on a split database where do I need to set this option. Is it sufficient to set it in the frontend database for record-level locking to apply to the backend tables. Or must I also set it in the backend mdb database instead or as well (which is never...
7
1908
by: Chris Davoli | last post by:
I need just opionions. I'm VB.NET programmer and I work with another front end HTML guy who doesn't know .Net and how to use the .Net controls. So far he has been unwilling or unable to learn .Net even though I have been training him, he hasn't caught on. He is good on "prettying up" the web pages in old HTML controls and javascript, which anybody can do. He says its better to do the front end first in HTML, then do the backend. By backend...
3
1715
by: Ian | last post by:
I have an Access 2000 database split front back end, what I want to do is have some kind of web based front end so users can logon via the internet and: 1. Enter new records, edit records in the database 2. Apply a filtering systems where records on a report can be limited to those matching a criteria, then print or PDF this filtered report including associated pictures.
18
4458
by: afromanam | last post by:
Whew.. OK, running access 2003 in win xpsp2 and access 2007 in win vista. This is the question... We have a db, split in front end (FE.mdb) and backend (BE.mdb) FE has tons of linked tables from BE.
0
8407
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
8739
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
8512
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
8612
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
7347
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...
1
6175
isladogs
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...
0
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2739
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
2
1732
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.