Creating new Access 97 database by VB code in Access 2000 module 
Author Message
 Creating new Access 97 database by VB code in Access 2000 module

I Create in an Access 2000 Visual Basic module a new database at the
following way:

    Set appAccess = CreateObject("Access.Application")            'Create
new access 2000 database
    appAccess.NewCurrentDatabase strDB
'Opens the new database to add some tables to

It always produce a new Access 2000 database

Although we need an Access97 database !!!! (the new database needs to be
compettible with some others who doesn't have access2000)

Who nows the solution for me?

Thanks for helping.
Bey bey



Mon, 29 Apr 2002 03:00:00 GMT  
 Creating new Access 97 database by VB code in Access 2000 module
Tools Menu\Database Utilities\Convert Database

or DoCmd.RunCommand acCmdConvertDatabase

Quote:

> I Create in an Access 2000 visual basic module a new database at the
> following way:

>     Set appAccess = CreateObject("Access.Application")            'Create
> new access 2000 database
>     appAccess.NewCurrentDatabase strDB
> 'Opens the new database to add some tables to

> It always produce a new Access 2000 database

> Although we need an Access97 database !!!! (the new database needs to be
> compettible with some others who doesn't have access2000)

> Who nows the solution for me?

> Thanks for helping.
> Bey bey



Mon, 27 May 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Converting VB code modules in Access 95 to Access 97

2. Importing an Access 2000 table into another Access 2000 database with VB Code

3. Transfer of Coding from Access 97 to Access 2000

4. Using VBA to Convert Access 2000 database to Access 97

5. Creating Modules in Access 97 using vba code

6. Accessing the modules of an Access 97 database.

7. Accessing the modules of an Access 97 database.

8. Accessing the modules of an Access 97 database.

9. VB app slower after converting database from Access 97 to 2000

10. Access 97 -> Access 2000 VB Scope Problem

11. Use VB to Detect Access 97 or Access 2000

12. Converting Modules from Access 97 to 2000

 

 
Powered by phpBB® Forum Software