473,326 Members | 1,972 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,326 software developers and data experts.

Can't open database in A2k

My client has a database that was written in Access97. The database
is password protected.

If I try to open the database by double-clicking on it, it asks for
the password. In Access97, I can enter the password and open the
database.

Similarly in Access 2003.

But not in Access 2000 - I get a "Not a valid password" error.

I have tried this on at least ten machines, with a variety of o/s and
flavours of Access. It always succeeds with A97 and A2k3, but always
fails with A2k.

Is there anything that I can do?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
Nov 13 '05 #1
4 1579
What is the password?

The best thing to do is change it in Access 97 or 2003 to something a bit
more A2000-friendly.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Edward" <te********@hotmail.com> wrote in message
news:25**************************@posting.google.c om...
My client has a database that was written in Access97. The database
is password protected.

If I try to open the database by double-clicking on it, it asks for
the password. In Access97, I can enter the password and open the
database.

Similarly in Access 2003.

But not in Access 2000 - I get a "Not a valid password" error.

I have tried this on at least ten machines, with a variety of o/s and
flavours of Access. It always succeeds with A97 and A2k3, but always
fails with A2k.

Is there anything that I can do?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 13 '05 #2
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:<41********@news.microsoft.com>...
What is the password?
The password is "rebadgemanager"

The best thing to do is change it in Access 97 or 2003 to something a bit
more A2000-friendly.
What would be more A2000-friendly - more to the point, why is
"rebadgemanager" *not* A2000-friendly?

Many thanks for your help.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk


--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Edward" <te********@hotmail.com> wrote in message
news:25**************************@posting.google.c om...
My client has a database that was written in Access97. The database
is password protected.

If I try to open the database by double-clicking on it, it asks for
the password. In Access97, I can enter the password and open the
database.

Similarly in Access 2003.

But not in Access 2000 - I get a "Not a valid password" error.

I have tried this on at least ten machines, with a variety of o/s and
flavours of Access. It always succeeds with A97 and A2k3, but always
fails with A2k.

Is there anything that I can do?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 13 '05 #3
I have no idea -- but the best way to proceed is to try changing it?

It may be a limitation with Access 2000 opening password-protected 97
enabled dbs? In any case, the database password is so entirely useless from
a security standpoint that you could just remove the password to save the
headaches....
"Edward" <te********@hotmail.com> wrote in message
news:25*************************@posting.google.co m...
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in

message news:<41********@news.microsoft.com>...
What is the password?


The password is "rebadgemanager"

The best thing to do is change it in Access 97 or 2003 to something a bit more A2000-friendly.


What would be more A2000-friendly - more to the point, why is
"rebadgemanager" *not* A2000-friendly?

Many thanks for your help.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk


--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Edward" <te********@hotmail.com> wrote in message
news:25**************************@posting.google.c om...
My client has a database that was written in Access97. The database
is password protected.

If I try to open the database by double-clicking on it, it asks for
the password. In Access97, I can enter the password and open the
database.

Similarly in Access 2003.

But not in Access 2000 - I get a "Not a valid password" error.

I have tried this on at least ten machines, with a variety of o/s and
flavours of Access. It always succeeds with A97 and A2k3, but always
fails with A2k.

Is there anything that I can do?

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 13 '05 #4
"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:<41********@news.microsoft.com>...
I have no idea -- but the best way to proceed is to try changing it?

It may be a limitation with Access 2000 opening password-protected 97
enabled dbs? In any case, the database password is so entirely useless from
a security standpoint that you could just remove the password to save the
headaches....


A quick update. I couldn't unset the password in Access 2003 - the
option was greyed out. I then opened the db in A97, where I removed
the password, and the db now opens fine in A2k. So many thanks for
your strategy, which worked.

Being a bit fastidious, and a completist, I would *still* like to know
why this happened, particularly because it had, until recently, worked
fine in all three flavours of Access. O well. Life's full of little
mysteries.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
Nov 13 '05 #5

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

Similar topics

46
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...
10
by: MHenry | last post by:
Hi, We were going merrily along for 6 years using this database to record all client checks that came into our office, including information about what the checks were for. Suddenly, network...
5
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I...
4
by: Macca | last post by:
Hi, I have an windows forms application that accesses a SQL database I have a few questions as to connecting to the database. This application will run 24 hours a day. It is a monitoring...
4
by: dennist685 | last post by:
Can't open my .mdb I was experimenting with opening an access database in IIS. For experimenting, I have an .mdb called HasbaraSample. In this case I copied it to the C:\Inetpub\wwwroot\Access...
1
by: dkintheuk | last post by:
Hi all, Just had the wierdest thing happen overnight to one of my databases. I have a frontend/backend set up with the front end under development on my machine. I was copying a load of old...
4
by: etuncer | last post by:
Hello All, I have Access 2003, and am trying to build a database for my small company. I want to be able to create a word document based on the data entered through a form. the real question is...
12
by: Steve | last post by:
I have a database that raises an error when you try to open it and it doesn't open. Trying to open the database with the OpenDatabase method raises the same error. Trying to import any objects...
5
by: Usman Jamil | last post by:
Hi I've a class that creates a connection to a database, gets and loop on a dataset given a query and then close the connection. When I use netstat viewer to see if there is any connection open...
1
by: billelev | last post by:
I am able to use the OpenCurrentDatabse method to open a new instance of an existing database and then open a form within that database. However, if the database I am interested in is already open,...
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...
1
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.