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

Converting toolbars from Access97 to Access2000 throug VBA

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
1 2602
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: NullRef | last post by:
Hello - I'm trying to create an ACCESS97 database MDB as well as tables w/in the db all programatically from VB.NET -- is this possible? I've seen examples for creating Access2000 database using...
2
by: michael montagne | last post by:
I need to import a custom toolbar into an Access2000 database. But I can't find anywhere to do it. Is it possible? -mjm
2
by: Richard Sherratt | last post by:
The system is an Access 97 front end to a SQL Server back end. There's a whole heap of VBA code. It has its own secure workgroup MDW. It uses automation to open and modify Word, Excel, and...
2
by: Marilyn Royce | last post by:
I did not create the original access 97 file. I do have administrative rights to the system and can do anything I want to in 97. When I try to convert it to 2000 it says that I do not have...
8
by: swilson513 | last post by:
In Access97 I was able to have an advance filter on a form that had a Like statement so when you applied the filter EACH time it would asked for the criteria. In 2000 the same filter doesn't asked...
4
by: MLH | last post by:
Is there a simple way to hide built-in toolbars in A97?
10
by: lesperancer | last post by:
you start with a small application in access97, then you have more modules and more... and you reach the point where tables like 'item' and 'employee' reach the limit and you know there's more...
12
LMHelper
by: LMHelper | last post by:
I am in the process of switching an Access Database that was originally designed in Access 97 and they need it to switch over to Access 2000-2003 Database Version. We have run into errors when moving...
15
by: Neil | last post by:
So, I tried to copy a toolbar. I have a custom menu bar for a form. Tried to copy it so that I could modify the copy and use it with another form. With no direct way to copy it, I made a copy of...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.