By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

Converting toolbars from Access97 to Access2000 throug VBA

P: n/a
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with
Access97 for several years now. We are in an Access97-2000 migration
project. I'm writing a wizard for the end-users to automatically find and
convert their Access97 databases on a specific drive.

I want to convert the databases through VBA :

1. create an empty Access2000
2. set the right properties and references
3. import the objects (tables, queries, forms, reports, macro's and
modules)
4. import the import/export specification files
5. import the custom menu's and toolbars

I have a problem with the last one : 'Import custom menu's and toolbars'.
How can I do that through VBA ? In Access97, there's a system table called
mSysCmdBar, where the menu and toolbars are defined. Access2000 doesn't use
this system table for keeping the toolbar definitions, so it's not possible
to use the toolbars by copying the system table from the Access97 database
to the Access2000 database.

Is there any way to import the custom toolbars throug VBA ?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
mario,

I think you'd better let Access do the conversion. It is eventually
possible to let a batchjob do it using commandline-parameters, but
converting any database this way could result in databases not
completely functional because of minor differences and problems
depending on features used (especially macro and VBA-code). Your
method often will fail because changes in default-libraries will
create lots of errors when using VBA. The built-in
conversion-functionality does by far the best job in converting older
databses to the newest release. Custom-toolbars will be correctly
converted as well, as do most library-references, most VBA-code, most
macro's etc and als your import-export specifications. You do avoid a
hell of a lot of work this way.
A batch-routine using commandline-parameters could do the job for a
directory at a time when used for in the batch-file.

it will look like:
for /r c:\ %%d in (*.mdb) do echo c:\..\msaccess.exe %%~fd /convert
%%nd2k.mdb

but you carefully have to test this routine before you can remove the
echo-statement generating command-lines on screen to make it work. see
the 'help for' commandline-output.

Marc

ma***********@bccomponents.com (Mario Crevits) wrote in message news:<b4**************************@posting.google. com>...
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with
Access97 for several years now. We are in an Access97-2000 migration
project. I'm writing a wizard for the end-users to automatically find and
convert their Access97 databases on a specific drive.

I want to convert the databases through VBA :

1. create an empty Access2000
2. set the right properties and references
3. import the objects (tables, queries, forms, reports, macro's and
modules)
4. import the import/export specification files
5. import the custom menu's and toolbars

I have a problem with the last one : 'Import custom menu's and toolbars'.
How can I do that through VBA ? In Access97, there's a system table called
mSysCmdBar, where the menu and toolbars are defined. Access2000 doesn't use
this system table for keeping the toolbar definitions, so it's not possible
to use the toolbars by copying the system table from the Access97 database
to the Access2000 database.

Is there any way to import the custom toolbars throug VBA ?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.