473,320 Members | 2,006 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

I'M LOCKED OUT OF MY DATABASE

When I came in on Monday and tried to open my database, everything
worked fine until I tried to run the database splitter. It didn't
work, but when I tried to go back into my database, it says I have no
permission. It doesn't even recognize me as the owner anymore.
Help. I have info that I need in there.

What did I do? How can I fix it?

Feb 27 '07 #1
1 2250
<bm****@yahoo.comwrote
When I came in on Monday and tried to open my
database, everything worked fine until I tried to
run the database splitter. It didn't work, but when
I tried to go back into my database, it says I have
no permission. It doesn't even recognize me as the
owner anymore.
Help. I have info that I need in there.

What did I do? How can I fix it?
Let me understand, here... you ran code on your database that would
drastically alter its structure without making a backup copy? And, was this
original and only copy of the database secured?

I've run the splitter on a few databases, but always on a backup copy in
several different versions of Access and never had a similar situation. In
fact, the splitter does so little for me that I don't use it, as a general
rule, preferrring to make two backup copies... on one I delete all but the
tables and relationships, on the other I delete relationships and tables,
then use Get External Data to link the tables in the first copy.

There's some possibility that your database was corrupted during the
Splitter process. To try to fix that, in case that is what it is,

*** FIRST, MAKE A BACKUP COPY, OR TWO ****

then Open Access without opening a database, on the menu Tools | Database
Utilities | Compact and Repair Database <and cross your fingers, and hope
for the best>...

If that doesn't work, go to the Microsoft site and download a copy of
JetComp, which does much the same, but doesn't require opening the database
first.

If neither of these works, then you need to be specific and precise about
_exactly_ what is happening, and the _exact_ error message you receive, not
a paraphrase.

At the very worst, you will have to go back to the last good backup copy you
have, and will have learned an OBJECT LESSON about the experts MEANING WHAT
THEY SAY when they advise making BACKUP COPIES before doing maintenance on
your database, as well as making BACKUP COPIES on a regular basis as you use
the database.

Larry Linson
Microsoft Access MVP
Feb 27 '07 #2

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

Similar topics

5
by: David C. Barber | last post by:
I'm trying to determine which user has locked a given record from VB6. I know I can use sp_lock and sp_who, and match up the data to determine which users have locked records in my database,...
6
by: DebbieG | last post by:
I have created a database for a client and was told that it was to be a one-user database. Well, you know the next statement ... now they want 3 people to be able to use the database. (FYI, I...
8
by: Lieve | last post by:
Hello, I set up a database a few months ago and placed it on our company network. In the beginning, there was no problem opening it, even when someone else was working in it at that time. The...
4
by: Chuck Insight | last post by:
Hi All, I just tried to follow some advice on securing a database. It worked great. So, figuring I learned my lesson, I deleted the original test database file and went to lunch. Unfortunately,...
4
by: hkappleorange | last post by:
I ued this code to connect to a mdb file A = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\Inetpub\wwwroot\ASPX\Authors.mdb" )
5
by: Glen Buell | last post by:
Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost...
8
by: kevin.vaughan | last post by:
Good Afternoon Everyone, Could someone please explain why I can't set the Subform control Visible attribute to False as below? The statement for the locked attributes work but not for the...
15
by: chaseexchange | last post by:
First, a brief explanation of why this has happened. I purchased, what I thought, was a fully functional program written in Access last year from a local programmer. This program was to be used as...
5
by: breal | last post by:
I have a db table that holds a list of ports. There is a column in_use that is used as a flag for whether the port is currently in use. When choosing a port the table is read and the first...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.