Using an A03 mdb in A07

[Neil]

I have an Access 2003 database that I need to be able to run on a machine
that's running 2007. Theoretically, it should work in both versions of
Access.

However, an associate of mine has reported that he had problems running his
A03 mdb in A07. Apprently, whenever he opened a form using the acDialog
property, the form opened as a single horizontal line (a "slither," as he
called it). He then resized the from in A07 and saved it in A07, and then it
opened fine with the acDialog property.

Has anyone else come across this behavior of A07? Are there any other issues
when using an A03 mdb in A07?

Thanks!

Neil

 

[Arvin Meyer [MVP]]

I have never come across this problem. If you do again, simply resize the
form in code. Form measurements are in twips. There are 1440 twips to the
inch (20 twips to a point, 72 points to an inch), so a 3 inch form would be
(aircode):

Sub Form_Open(Cancel As Integer)
Dim twp As Integer
twp = 1440
Me.Height = 3*twp
End Sub

 

[Neil]

The person having this problem is using an A02/A03 format mdb in A07 (as
opposed to an A00 format mdb in A07). I wonder if that has any bearing on
it.

Thanks for the note. I'll pass that on to him.

 

[Arvin Meyer [MVP]]

It may be a bug between those 2 versions only. I only use Access 2000 format
so that it is available in all later versions, so I don't have any files I
can use to check. The code should work in any version.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com