Upgrade From Access2002 to Access2003

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have upgraded 2002 to 2003. I have several issues that
are 2003 specific.

1. I can't get the XP Styles to work.
2. When i use the 2003 Developer Extentions for Access
2003, I can't check references. I get a vb6 .dll error.
3. When i distribute the File to a runtime version, i get
a license not avalible for this function error. It works
on my machine.

Dim appAccess As New Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase CurrentProject.Path
& "\" & CurrentProject.name
Application.Quit
 
I'll take the easy one! :-)

I'll answer number 3, hopefully someone else may have a try at 1 and 2. (You
might want to post a follow-up expanding a bit on 'can't get the XP Styles
to work'. I'm assuming you mean Windows XP themed controls support? If so,
what is it about the feature that doesn't work?)

The answer to number 3 is, I'm afraid, that you can't do that - you can't
automate the runtime. The user would need retail Access installed.

There are a couple of other things about that code that look a bit strange -
you can't declare a variable as Access.Application without a reference to
the Access object library, and if you have a reference, why use late
binding? Also, the application appears to be trying to open itself!

But those points are a bit academic in view of the fact that you just can't
do it with a runtime installation anyway.
 
Well, it's good to see an answer. Thank you. I was using
the shell command before this automation. I went back to
it. 3 was actually the most minor question... thanks
though.

Opening itself, yeah, well restarting the access app
actually. Thanks for the link. That could be helpful in
the future.

Reply to reply:
1. What about the styles don't work? Well the buttons
remain the same, so do the check boxes and the option
selections, tab bars etc.... The tool bars work like the
new ones.

2. There is another post on this site where someone had
this problem. I still haven't worked through it.
 
Back
Top