"Not a valid Password" in Access2000

M

Mohsen

Hello Everyone

I have 2 database that locked with "Database Password".
Then I want create one Union query from these MDBs. But I
give a message "Not a valid Password" in Access2000.

MDB1 MDB2
Siaq1382 Siaq1383

First I connect to Siaq1383.

Then Write

{
Select SM.No, SM.Date, SM.PersonID From SM Union Select
SM.No, SM.Date, SM.PersonID From SM In 'Siaq1382'[;PWD=XXX]
}
but not answered.

Please help me that message appear for What?

Sincerely yours,
Mohsen Darrehshiri
 
R

Raghu Prakash

Hi Mohsen,

SYMPTOMS
Using the Microsoft Access ODBC driver, you can repair or compact a
Microsoft Access database. This functionality is accessable from the ODBC
Control Panel, through the ODBC Microsoft Access Setup dialog box. This
repair and compact functionality works correctly for non-password protected
databases. However, when you attempt to repair or compact password
protected databases, the repair or compact fails with the following error
message:

Not a valid password
RESOLUTION
This problem is fixed in the latest service packs for Windows 2000 and MDAC
2.5.
To resolve this problem, obtain the latest service pack for Windows 2000.
For additional information, click the following article number to view the
article in the Microsoft Knowledge Base:
260910 How to Obtain the Latest Windows 2000 Service Pack

To resolve this problem, obtain the latest service pack for Microsoft Data
Access Components 2.5. For additional information, click the following
article number to view the article in the Microsoft Knowledge Base:
293312 INFO: How to Obtain the Latest MDAC 2.5 Service Pack

The English version of this fix should have the following file attributes
or later:
Date Version Size File name Platform
--------------------------------------------------------
08/29/2000 4.0.5629.0 270,608 Odbcjt32.dll x86
WORKAROUND
One workaround is to use the JetComp tool that is included with Microsoft
Jet 4.0 Service Pack 4. JetComp is a standalone tool that allows you to
repair and compact a Microsoft Access database, even if Microsoft Access is
not installed on the computer.


STATUS
Microsoft has confirmed that this is a problem in the Microsoft products
that are listed at the beginning of this article. This problem was first
corrected in Microsoft Data Access Components 2.5 Service Pack 2 and
Microsoft Windows 2000 Service Pack 2.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top