Using Form Between 2002/2007

  • Thread starter Thread starter Brenda from Michigan
  • Start date Start date
B

Brenda from Michigan

User has Access 2002 SP3

User has an every 3-year process whereby an Access 2002 form is sent out to
registrants of a program to be completed and returned. However, they are now
finding that many of the registrants have Access 2007 and none of the
detailed instructions on how to handle this form apply. We need to find a
way to provide instructions to use this form in Access 2007 when none of us
have this version of the program. Additionally, when these forms are
returned after having been completed in Access 2007, will the data be
good/available/usable in Access 2002?

This is an important process on order to maintain certification, so we need
to find a way to make this work. Can anyone offer us any advice? Thanks !
 
User has Access 2002 SP3

User has an every 3-year process whereby an Access 2002 form is sent out to
registrants of a program to be completed and returned. However, they are now
finding that many of the registrants have Access 2007 and none of the
detailed instructions on how to handle this form apply. We need to find a
way to provide instructions to use this form in Access 2007 when none of us
have this version of the program. Additionally, when these forms are
returned after having been completed in Access 2007, will the data be
good/available/usable in Access 2002?

This is an important process on order to maintain certification, so we need
to find a way to make this work. Can anyone offer us any advice? Thanks !
Click to expand...

Could you explain how you're sending out "a form"? An Access form, in either
version, has no existance outside a database. Are you sending a .mdb file wit
a form and tables, or what?
 
Here are the instructions that are sent out to the people. Does this help?

Attached to an e-mail is the Service Agency Profile set of databases for the
CMH. WINZIP needs to be used to extract the two databases inside the zip
file. Both databases need to be extracted to the same folder on a computer or
network drive. All work needs to be done through the “forms†database. The
“forms†database will automatically link to the “data†database.

Extract both database files to a disk on a PC or network drive.

The CMHSP will open (use Windows Explorer and double click) the Service
Agency Profile form – CMHSP.mdb.

After the CMHSP makes all the necessary changes, the CMHSP will send the
“data†database (Service Agency Profile data – CMHSP.mdb) to {agency name},
to update our records as part of the certification process.
 
Here are the instructions that are sent out to the people. Does this help?

Attached to an e-mail is the Service Agency Profile set of databases for the
CMH. WINZIP needs to be used to extract the two databases inside the zip
file. Both databases need to be extracted to the same folder on a computer or
network drive. All work needs to be done through the “forms” database. The
“forms” database will automatically link to the “data” database.

Extract both database files to a disk on a PC or network drive.

The CMHSP will open (use Windows Explorer and double click) the Service
Agency Profile form – CMHSP.mdb.

After the CMHSP makes all the necessary changes, the CMHSP will send the
“data” database (Service Agency Profile data – CMHSP.mdb) to {agency name},
to update our records as part of the certification process.
Click to expand...

OK... so it is actually a split database you're sending out, not a Form. That
makes sense!

I can see that A2007 might cause some confusion. What specific errors are the
users getting? Do you have a copy of 2007 somewhere which you could use for
testing? I would expect that 2007 could be used to do what you need done, but
the instructions and steps to do so might be different; you'ld need a way to
test the app in 2007 to write the instructions.

Alternatively, you might obtain the A2003 runtime license and actually send
out a runtime version. Since your clients already have a different version
installed, though, this would need to be done with care, and you'ld *still*
need a test machine with 2007 installed to work it out!

Any chance you can get an upgrade?
 
Upgrade? Not very likely. Government, no money, etc. I don't know about
a testing copy, so this may have to go higher in the organization and I can
help this lady at this time.

However, would you not have a round-robin with this trying to service both
2002/3 and 2007?
 
Upgrade? Not very likely. Government, no money, etc. I don't know about
a testing copy, so this may have to go higher in the organization and I can
help this lady at this time.

However, would you not have a round-robin with this trying to service both
2002/3 and 2007?
Click to expand...

I'm HOPING that you would be able to just revise the instructions to explain
what hoops the user needs to jump in order to run the app in 2007. The app
might not need anything changed; I suspect the 2007 user would need to put the
database into a Trusted Location, but I don't know what if any other changes
would be required.
 
Thanks for your input. The long and the short is that this is an issue that
needs to be addressed higher up in the organization that I am able to do.
For one thing the idea of having a test version of 2007 just to be able to
write up appropriate instructions needs to be blessed from above.

Thanks again. You've been very helpful!

- Brenda
 
Thanks for your input. The long and the short is that this is an issue that
needs to be addressed higher up in the organization that I am able to do.
For one thing the idea of having a test version of 2007 just to be able to
write up appropriate instructions needs to be blessed from above.
Click to expand...

I'd almost be tempted to see if there's somebody local with an office or home
installation of A2007 who'd be willing to let you spend half an hour, off the
government's time, to try it out. Sometimes what the Bosses don't know
happened won't hurt them...
 
Back
Top