Deployment Help!?

[Tim Burke]

I created a simple Access DB in 2007 as a front-end to entering data into SQL
Server.

Everything runs fine on my PC that has Access installed. When I open the
ACCDB, ACCDE or ACCDR, I get prompted to log in to the DB. I can add, edit
and delete records. When I click on the Exit button, everything
closes...just like it should.

I created an installation package with Access Runtime extensions and
packager. I run the installation on a PC without MS Access. It seems to
install correctly. When I go to open the ACCDR or ACCDE, I get a dialog that
says the runtime need to configure itself. This runs for a while, then the
main form pops up (no log in to the database appears) and none of the buttons
work.

Anyone have any ideas?

Thanks in advance for any assistance.

Tim

 

[Stuart McCall]

I created a simple Access DB in 2007 as a front-end to entering data into
SQL
Server.

Everything runs fine on my PC that has Access installed. When I open the
ACCDB, ACCDE or ACCDR, I get prompted to log in to the DB. I can add,
edit
and delete records. When I click on the Exit button, everything
closes...just like it should.

I created an installation package with Access Runtime extensions and
packager. I run the installation on a PC without MS Access. It seems to
install correctly. When I go to open the ACCDR or ACCDE, I get a dialog
that
says the runtime need to configure itself. This runs for a while, then
the
main form pops up (no log in to the database appears) and none of the
buttons
work.

Anyone have any ideas?

Thanks in advance for any assistance.

Tim

Have you declared the accdb folder as a trusted location?

 

[Tim Burke]

When the dialog appears asking if this is a trusted program I click yes. Is
there something I need to do beforehand to set anything else up?

Thanks!

 

[Stuart McCall]

When the dialog appears asking if this is a trusted program I click yes.
Is
there something I need to do beforehand to set anything else up?

Thanks!

I have no experience of Access 2007 or the runtime yet, so this'll have to
be a guess. If your app does not reside in a trusted location (which you set
somewhere in Access Options), none of your code will run (at least that's
how I understand it from reading posts here). So, say your development app
lives in c:\apps then ensure you install to c:\apps on the client's machine.

I have no idea if this will work, but it wouldn't take long to test it and
see...

 

[Tim Burke]

Stuart,

Thanks for your help, but I'm just not getting something right.

The installer from the runtime install keeps popping up and I'm still
getting security measures.

Tim

 

[Stuart McCall]

Stuart,

Thanks for your help, but I'm just not getting something right.

The installer from the runtime install keeps popping up and I'm still
getting security measures.

Tim

Perhaps someone with experience of Access 2007 could jump in here?...