Deployment Help!?

  • Thread starter Thread starter Tim Burke
  • Start date Start date
T

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
 
Tim Burke said:
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
Click to expand...

Have you declared the accdb folder as a trusted location?
 
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!
 
Tim Burke said:
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!
Click to expand...

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...
 
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
 
Tim Burke said:
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
Click to expand...

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