Jane,
You might want to try running your application with the runtime instead of
full access. I have a virtual machine without office installed to do that
sort of testing but it is possible also to use the /runtime switch in your
normal environment. See this article
<http://support.microsoft.com/kb/209207> .
You will have to change how you modify the recordsource, captions, etc. as
you won't be able to open anything in design view. To do this you use a
statement that assigns what you want to the relevant property of the form,
control, etc. For the recordsource of a form, for example, you can assign an
sql statement. On caution, test your sql in a normal query to make sure a)
that it works and b) that it works correctly. If your sql isn't quite
correct, you won't necessarily see an error. An error in a combo's
recordsource, for example, just displays an empty list.
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jane
Sent: Tuesday, July 30, 2013 6:47 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Runtime 2007 with Access 2003 db
Hi
I have developed an extensive database in access 2003, with user-level
security.
I've just been asked if it will run under the runtime 2007. It runs fine
with Access 2007. From what I've read, I might have issues with menus and
the default shortcut menu won't work.
I have code that changes the recordsource of forms and reports and a couple
of labels/captions (the reports are opened in design view, changed & saved).
It also changes the default printer (there is a table of reports, users and
the printer that the report should come out on). I'm guessing that these
won't work as it design view. So how do others change reports design items?
Also is there anything else anyone has come across, that I don't know about?
Many thanks
Jane
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar