H
Huckle
Sorry for the length... I'm having trouble deploying my db and I've searched
through these threads and through the MS Knowledge Base and haven't been able
to find an answer, but maybe I'm asking the wrong questions
Background: I've updated my front-end db to Access 2003. I'm using the
built-in security for Access (workgroup file). I'm using the Package Wizard
included with Visual Studio to deploy the database. All users of the
database are on a local network running XP, but some don't have Access
installed at all and others have older versions (probably 2000). No one uses
databases other than the one(s) I deploy.
Issue 1: When I go to update the database on a user's computer, and use the
install package for the second time on a machine, it says "Another version is
already installed... Use the Add/Remove programs..). This message comes up
whether or not I include the run-time files on the second install package
(run-time was included in first one). Is there a way to create a package
that overwrites the old front-end?
My workaround so far has been to create a new .mde file and replace
(copy/paste) the one installed from the first package I created on each
user’s computer. It seems to work fine, but it’s annoying to pay so much $
for the Developer Extensions and then need workarounds (fine for my local
network, but if I was distributing to customers…).
Issue 2: This is a side note, but the add/remove program in the control
panel does not seem to work for removing your program. From what I can tell,
you need to re-run the setup.exe from your original install and then remove
from there. No big deal, but is that the way it's supposed to happen?
Issue 3: I digitally signed the code and figured out how to add me as
someone to always trust on each user's computer. I still get two dialog
boxes that are really annoying. The first says "Unsafe expressions are not
blocked... do you want to block this..." so you have to click NO. Then the
next pop-up says "Unsafe expressions are not blocked, to block them... do you
still want to open the program...", then you have to click YES. How can I
get rid of these? I tried going to Tools>Macro>Security in an office program
and set the security level to Low and the dialog boxes still came up (went
back to Medium).
Issue 4: I have a few references in my database such as “Microsoft DAO 3.6
libraryâ€. I had a piece of code on my splash screen (first form that opened)
that used a DCOUNT function that I believe references the DAO3.6 library, and
an error came up that killed the database. Once I removed the code, it opened
fine. How can you get references to work?
Issue 5: When the program opens on a user’s machine, it appears that the
run-time version of access stripped the program WAY DOWN. It appears that
you can not filter records which are one of the main functions of the
database. Do I have to create all custom menus and filtering code to add
basic functionality such as filtering tools?
Any help would be greatly appreciated. Thanks in advance.
through these threads and through the MS Knowledge Base and haven't been able
to find an answer, but maybe I'm asking the wrong questions
Background: I've updated my front-end db to Access 2003. I'm using the
built-in security for Access (workgroup file). I'm using the Package Wizard
included with Visual Studio to deploy the database. All users of the
database are on a local network running XP, but some don't have Access
installed at all and others have older versions (probably 2000). No one uses
databases other than the one(s) I deploy.
Issue 1: When I go to update the database on a user's computer, and use the
install package for the second time on a machine, it says "Another version is
already installed... Use the Add/Remove programs..). This message comes up
whether or not I include the run-time files on the second install package
(run-time was included in first one). Is there a way to create a package
that overwrites the old front-end?
My workaround so far has been to create a new .mde file and replace
(copy/paste) the one installed from the first package I created on each
user’s computer. It seems to work fine, but it’s annoying to pay so much $
for the Developer Extensions and then need workarounds (fine for my local
network, but if I was distributing to customers…).
Issue 2: This is a side note, but the add/remove program in the control
panel does not seem to work for removing your program. From what I can tell,
you need to re-run the setup.exe from your original install and then remove
from there. No big deal, but is that the way it's supposed to happen?
Issue 3: I digitally signed the code and figured out how to add me as
someone to always trust on each user's computer. I still get two dialog
boxes that are really annoying. The first says "Unsafe expressions are not
blocked... do you want to block this..." so you have to click NO. Then the
next pop-up says "Unsafe expressions are not blocked, to block them... do you
still want to open the program...", then you have to click YES. How can I
get rid of these? I tried going to Tools>Macro>Security in an office program
and set the security level to Low and the dialog boxes still came up (went
back to Medium).
Issue 4: I have a few references in my database such as “Microsoft DAO 3.6
libraryâ€. I had a piece of code on my splash screen (first form that opened)
that used a DCOUNT function that I believe references the DAO3.6 library, and
an error came up that killed the database. Once I removed the code, it opened
fine. How can you get references to work?
Issue 5: When the program opens on a user’s machine, it appears that the
run-time version of access stripped the program WAY DOWN. It appears that
you can not filter records which are one of the main functions of the
database. Do I have to create all custom menus and filtering code to add
basic functionality such as filtering tools?
Any help would be greatly appreciated. Thanks in advance.