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

Calling upsizing wizard from VBA

P: n/a
I'm looking to call the upsizing wizard from within a VBA function,
preferably automating the entire upsizing process. Has anyone achieved
this under Access 2003?

The best I've managed so far is to .Execute its CommandBar control, but
this is a pretty messy approach and still requires input on the part
of the user.

Anyone know of a direct function call similar to those detailed at
http://www.mvps.org/access/general/gen0028.htm?

Thanks in advance,
Calum

--
Any views or opinions expressed in this message are those of the sender
and do not necessarily coincide with those of Ingen Process Ltd.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I guess my question would be "Why?" How often do you convert your MDB with
Jet to a client-server database application that you need to do so from VBA?
It's a very, very rare occurrence for most of us -- in fact, I've never used
the upsizing wizard, although I've worked on a number of C/S applications
that began life as MDB-Jet.

In our case, the server database DBA used his Data Modeling software to
re-create the table structure, and set up the Data Source Name. We linked
the tables, and used APPEND queries to populate existing or test data, if
needed. We then took the old MDB, deleted the original tables, and linked
the server tables under the same name.

That was using MDB - Jet - ODBC - server. It will be a little different
going to ADP - ADODB - SQL Server, but still seems to me to be a rather
infrequent occurrence. And, the tweaks to make a "good" singleuser MDB into
an equally "good" client application may be subtle and unobvious, and I
think they would be near-impossible to automate.

All that notwithstanding, if you have figured out a way to simplify the
process and automate it, I suspect you'll find a good many customers for
such a product. I wish you much luck.

Larry Linson
Microsoft Access MVP
"Calum Chisholm" <ca************@removethisbit.ingen-ideas.co.uk> wrote in
message news:c8**********@news0.ifb.net...
I'm looking to call the upsizing wizard from within a VBA function,
preferably automating the entire upsizing process. Has anyone achieved
this under Access 2003?

The best I've managed so far is to .Execute its CommandBar control, but
this is a pretty messy approach and still requires input on the part
of the user.

Anyone know of a direct function call similar to those detailed at
http://www.mvps.org/access/general/gen0028.htm?

Thanks in advance,
Calum

--
Any views or opinions expressed in this message are those of the sender
and do not necessarily coincide with those of Ingen Process Ltd.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.