Failing to Open Frontend - Microsoft Access / VBA

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

Subscribe Post Reply

1781

NeoPa

32,556

Expert Mod 16PB

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,556

Expert Mod 16PB

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

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,556

Expert Mod 16PB

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

Similar topics

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

Microsoft SQL Server

Can't Open Anymore Databases

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

Microsoft Access / VBA

Problems Caused By Several Users Using A Single Frontend

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

Microsoft Access / VBA

115

Open source alternative for MsAccess?

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

Microsoft Access / VBA

Access 2000 Network Database Freezes on Open

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

Microsoft Access / VBA

Failing unittest Test cases

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

Python

Open mdb exclusive, permissions problem.

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

Microsoft Access / VBA

Any idea how to open Matlab and run M-files by using Python?

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

Python

Can open DB multiple times but only on one PC

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

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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,...

General

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

Windows Server

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,...

C / C++

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

General