473,806 Members | 2,346 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Failing to Open Frontend

25 New Member
i want to share my database on a workgroup,and curently i have both the front end and the backend on the workgroup server.The problem is when i share the frontend to the other clients ,the front end is failing to open ,it is trying to access the backend from the same directory it is on the server but this time looking on the client computer,and thus it is returning an error that the path cannot be found.in other wordas it seems not to link to the backend on the server ,it is trying to look for the backend in its own c drive
what can be the problem, i have joined the workgroup and i have all the permissions.
Nov 19 '07 #1
4 1803
NeoPa
32,579 Recognized Expert Moderator MVP
You have (accidentally) posted this question in the Access Articles section. This is NOT an article.
I'm moving this to the main Access questions forum.

ADMIN.
Nov 19 '07 #2
NeoPa
32,579 Recognized Expert Moderator MVP
Have a look at (Front-End / Back-End (FE/BE)) to see how this should be done.
Any relative links (linked tables) must be set up to work from wherever the Front End is run from. This is part of the fundamental design of a working FE/BE system.
Nov 19 '07 #3
bowtie
25 New Member
Have a look at (Front-End / Back-End (FE/BE)) to see how this should be done.
Any relative links (linked tables) must be set up to work from wherever the Front End is run from. This is part of the fundamental design of a working FE/BE system.
i have checked the post on front and backends ,i did so on my database only that i used the database splitting wizard,dont know if they would be any difference,sut still the problem is the same
Nov 20 '07 #4
NeoPa
32,579 Recognized Expert Moderator MVP
I suspect your problem is that the references to the back-end database were put in without considering where it would be run from. It appears the article doesn't make this clear either - I'll need to update it (* Edit * Done now).

Consider the PC you do the splitting work on.
If it has a P: drive (or worse C: drive) pointing to the BE database, but the P: (or more obviously for C:) drive is not accessible via the same letter on any of the PCs you will be running the FE database on, then you cannot get away with linking to the BE database on that drive (at least not using the drive letter).
If this is your situation use a UNC to connect to the database that you're linking to and you should find it works for you.
Nov 20 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

3
2543
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.
46
6034
by: Steve | last post by:
Access97 Database The database is split into a frontend and backend and not connected to any other database. The database has an unbound report with 15 subreports. Some of the subreports include Excel charts in unbound object frames. When I add 3 additional subreports, I get the error message that Access can't open any more databases. Can anyone suggest what may be causing the error message. Thanks!
16
2219
by: Wayne Aprato | last post by:
I have several Access 97 databases which are split into front end and back end running off a server. The front end mde is shared by 2 or 3 - absolute maximum of 6 concurrent users. This scenario has been working flawlessly for about 2 years. I am now at a point where these databases need to be converted to Access 2003. I think I read somewhere on this forum that the newer versions of Access are not as tolerant to multiple users...
115
14206
by: TheAd | last post by:
At this moment I use MsAccess and i can build about every databound application i want. Who knows about a serious open source alternative? Because Windows will be a client platform for some time, i prefer a solution that (also) supports Windows. On the net I found a number of products that i looked at, but none of them gave me the impression of a serious candidate at this moment (KNoda, Gnome DB Manager, InterBase...). 2 additional...
2
1931
by: FMR | last post by:
I have an Access 2000 application that has a backend database which sits on the network and a frontend installed to each PC. When the frontend is opened, users have to log on and then the database opens their menu form with buttons for key activities. The problem I am having is that the user is logging on then there is a delay before the menu form opens (normally this is really fast) and then the application freezes - they can't push...
18
1883
by: Scott David Daniels | last post by:
There has been a bit of discussion about a way of providing test cases in a test suite that _should_ work but don't. One of the rules has been the test suite should be runnable and silent at every checkin. Recently there was a checkin of a test that _should_ work but doesn't. The discussion got around to means of indicating such tests (because the effort of creating a test should be captured) without disturbing the development flow. ...
0
4974
by: Salad | last post by:
A97. Split database. Frontend DB1.MDB. Backend DB1BE.MDB. Tables are linked between DB1 and DB2. From my testing, if I open DB1 exclusively using /excl the backend DB1BE is not opened exclusively. If I open DB1 but have no tables open and then open up DB1BE exclusively, DB1BE will open exclusive. But if I then attempt to open a linked table in the frontend DB1 I'm informed I can't use the table because the file is in use.
4
13757
by: itcecsa | last post by:
Hi, I am implementing a small Python project, what I am going to do is to open Matlab and run some M-files, and get some output from Matlab command prompt. I have no idea how to open Matlab from Python! Any suggestions would be appriciated!
3
2083
by: Barry Edmund Wright | last post by:
Hi All, I have an MS Access DB (2003) with frontend on PC (xp) and backend on Server (2003). I can open multiple instances from this PC. I make a duplicate copy of the MS Access DB and put it onto another PC and I can only open one instance. Does anyone know what would be preventing it from opening multiple time on the one PC but not on the other. I am NOT using an MDW file and the shortcut target is just: C:\Volunteer\Volunteer.mdb ...
0
10366
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
10371
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
9187
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
7649
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
5546
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...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4329
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
3850
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3008
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.