Hi Spock,
Most Access 2000 databases should operate normally when opened with
Microsoft Office Access. You can run into situations where there are missing
references, but that can also happen using the same version of Access on two
different computers. Here is more information on the topic of missing
references:
Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html
Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
I suspect that you might be running into an issue with expressions getting
blocked in Sandbox mode, in Access 2003. The Time and Billing template
database has a known issue with this. You can fix the problem by creating a
user-defined function (UDF) that calls the blocked function. However, this is
not a task that a new user should be expected to do, especially with a
template sample. If you wish to send me a private e-mail, I can give you more
details on how to create a UDF.
Try opening your template database in Access 2003 using the following steps:
1.) First, set macro security to low. Click on Tools > Macro > Security...
Even though Microsoft does not officially recommend this, a setting of Low
should not be a problem if you a.) have up-to-date anti virus software and
b.) never open an Access database that someone sends to you, unless you know
of a reason for receiving it.
2.) If you see a message that reads:
"Unsafe expressions are blocked. You can configure your computer to allow
all expressions to be evaluated."
Click Yes.
3.) If you see a message that reads:
"Security Warning: Unsafe expressions are not blocked."
"Do you want to block unsafe expressions?"
make sure to click No (you don't want to block any expressions).
You will need to quit Access and re-start it before the setting will take
effect.
Tom
QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
___________________________________________
:
I recently purchased MS Office 2003 Pro and have also found several Access
2000 templates I would like to use. Unfortunately, the base database engines
seem to be different enough that there is no immediate conversion.
Does anyone know if it is possible to convert Access 2000 databases to
Access 2003 or if there is some simple way to get such converted copies?
