Access 2.0 VB 3.0 compact/repair not working 
Author Message
 Access 2.0 VB 3.0 compact/repair not working

I've developed an Access 2.0 application that needs a compact and repari utility for
users who do NOT have Access 2.0 (or any version of Access). I have the Visual Basic
3.0 script "RepairDatabase d:\table.mdb" and "CompactDatabase d:\table.mdb" which works
like a champ on MY computer and MY version of Access.  However, if I run this code on
any other user's computer (REGARDLESS of how I've set the permissions).  The message
"Not a vaild Account Name or Password" appears.  

I thought changing the permissions would fix the problem, but I've granted every user
and group every possible permission...but it still blows.  

Any and all help will be DEEPLY appreciated.

PLEASE REPLY BY E-MAIL

Rita



Fri, 28 May 1999 03:00:00 GMT  
 Access 2.0 VB 3.0 compact/repair not working

Have you remembered to call SetDefaultWorkspace in your repair/compact
program?

HTH
        Ade.



Quote:
> I've developed an Access 2.0 application that needs a compact and repari
utility for
> users who do NOT have Access 2.0 (or any version of Access). I have the
Visual Basic
> 3.0 script "RepairDatabase d:\table.mdb" and "CompactDatabase

d:\table.mdb" which works
Quote:
> like a champ on MY computer and MY version of Access.  However, if I run
this code on
> any other user's computer (REGARDLESS of how I've set the permissions).
The message
> "Not a vaild Account Name or Password" appears.  

[cut]

Quote:
> PLEASE REPLY BY E-MAIL

No, sorry.

--
----------------------------------------------------------------------------

All opinions expressed are (c)1996 Adrian Vickers. Opinions should only be
shared if you are using a sterilised computer. Always wash your eyes before

viewing. Please use the approved eyecups (40ukp extra each, plus VAT & P&P)

----------------------------------------------------------------------------



Sat, 29 May 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Help: Access 2.0 Function does not work with VB 3.0

2. Compact/Repair of Access 2.0 DB in VB3

3. Compact and Repair not working in JRO?

4. Compact and Repair not working in JRO?

5. Install Access 2.0 Cmpt Layer w/o Access 2.0 for VB 3.0

6. How do I get VB 3.0 Pro to work with Access 2.0

7. VB 3.0, Access 2.0 and Crystal Reports 2.0

8. Access 97: help with VB code for repair and compact on NT 4.0

9. Compact & repair Access 97 db from VB

10. compact + repair an access d/b from VB

11. Compact & repair Access 97 db from VB

12. Repair/Compact access 2000 database in vb

 

 
Powered by phpBB® Forum Software