472,371 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,371 software developers and data experts.

I just inherited an Access Database but I cannot access any data

A little about me... Iíve build a few Access dbases but I consider myself a novice. I have never inherited someone elseís Dbase. The dbase is not password protected, but I cannot access all of the components. Some tables & some queries, yes, but not all. When I access the dbase from someone elseís computer ( logged on as that person), I have compete control.

When I try to access the dbase as myself, this is the error I get
' The Microsoft jet database engine cannot open the file "......mdb". It is opened exclusively by another user, or you need permission to view its data.

Today is Saturday, no one else is here to use the dbase, so I must need permission. Has anyone ever had this problem? Please advise. Thank you in advance.
Sep 12 '09 #1
3 1627
32,511 Expert Mod 16PB
This sounds like the file is already locked by another user (Look for the .LDB file). If not that, then your network account may not have read/write access to the file.
Sep 12 '09 #2
8,832 Expert 8TB
Are all PCs using the same Workgroup Information File (*.mdw)?
Sep 12 '09 #3
3,532 Expert 2GB
Since we're obviously talking about a database with multiple users, the first thing I wondered was whether or not this is split into front end and back end, with the back end (with data) on the shared network drive and a copy of the front end on each user's PC? Trying to access a single, non-split database, located on a network, from multiple machines, can lead to all kinds of hinky behavior, including things you've mentioned here.

Welcome to Bytes!

Linq ;0)>
Sep 12 '09 #4

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

Similar topics

by: DD | last post by:
Hello, Could anyone please help me?? Is there somebody who could explain me how to make a connection to a access database with a python cgi script. I would like to use common sql commands in my...
by: SLE | last post by:
Hi there, I know constructors are not inherited from the base class, not in VB.NET nor C# (nor Java I suppose). I never wondered,but reflecting on the reason why, I cannot find a solid answer. ...
by: bettina | last post by:
I have exported my old Access database to MySQL. I am used to using the possibilities of Access to retrieve, for example, for a definite column, the values in a column of another table (through a...
by: sdbranum | last post by:
I have been using Visual C#.NET to code a large project having many data adapters, data sets, datagrids, multiple forms with tab pages, each containing various controls (mostly label, text boxes,...
by: Russell Read [MSFT] | last post by:
Hi all, I am using VB script in ASP to access a MS Access database. This works fine until I want to access the same db placed on a file share. The code I am using is... 'create connection...
by: Paul Michaud | last post by:
Consider the following: Class A { .... } Class B:A { ....
by: Enska | last post by:
I have problems connecting my access database I get information .. I cant use my database and I'm administrator on my computer so permission shutnot bee problem, but I dont know Where is the...
by: Mihai | last post by:
Hi ! I use VB.Net 2005. I created an inherited user control based on a previosly created user control.Everything is Ok . I can run this control with f5, everything is fine. When I close Visual...
by: raylopez99 | last post by:
I am trying to program a database from inside C++.NET via Visual Studio 2005 using the ADO.NET set of classes, but this I believe is a SQL Server 2005 Express permissions question under Windows XP...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Johno34 | last post by:
I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

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.