Copying mdb file to another pc

[Guest]

The mdb file (created by Access 2003) that contains serveral VB routines must
be run on another pc (500 miles away) that runs Access 2007. Attempts to
send the file via CDs has not worked. The large mdb database with the VB
routines will not even open without errors. A simple three record, two
format, test database (no VB routines)will work but a simple database with a
switchbord opens only with the switchboard buttons and no text. I suspect
problems with referenced objects, DLLs, etc in the database. Is there a
step-by-step procedure that one can recommend to facilitate this database
transfer. Is it simply a case of verifying that all the references used on
the 2003 pc are also on the 2007 pc?

 

[strive4peace]

Hi Bobby,

before the database that you transfer is "run", it must be compiled in
the new environment (does it compile in the 2003 environment without
errors?)

for compiling in Access 2003:

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

~~~~~~~~~~~~~~~~~~~~~~~


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Aaron Kempf]

MDB is unreliable

and it shouldn't ever be used by a database that large

use Access Data Projects; keep all your data in one place and give people
VPN connections

 

[Guest]

Thanks, Strive4peace. The 2003 compilation had no errors and the application
ran like a charm. What do you mean by: "from the menu in the module?"
Understand the need for recompiling in the new environment. Is the 2003 mdb
file the source for recompiling? What module (application) should be
launched for the compilation.

 

[Guest]

Thanks, Strive4peace. The 2003 compilation had no errors and the application
ran like a charm. What do you mean by: "from the menu in the module?"
Understand the need for recompiling in the new environment. Is the 2003 mdb
file the source for recompiling? What module (application) should be
launched for the compilation?

 

[Guest]

Hi

I dont think it is anything to do with compiling the MDB, A2007 uses a
different security model and disables macros and code for databases that are
not considered safe, the simplest thing to do is add the folder the database
is stored in to the trusted locations for Office you can do this by using the
office trust centre, you can get the database working without doing this just
below the ribbon is a button (I think it says error, I am not on a machine
that has A2007 at the moment to check but it is a single button on its own)
if you press this it should give you the option to run code on the database,
the switchboard will now open and work correctly.

HTH

PHil

 

[strive4peace]

making trusted location for Access 2007
---


Hi Bobby,

you're welcome

Phil has a good point about the Access 2007 security

MVP Garry Robinson made a video about how to set up a trusted location
for your databases in Access 2007:

http://vb123.blogspot.com/

MVP Tom Wickerath also has a web page for managing macro protection:

Dealing with the Trust Center
http://www.access.qbuilt.com/html/trust_center.html


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

good point, Phil!

I gave Bobby some instructions on setting up a trusted location in
another message on this thread

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Thanks

happy to help

Phil

good point, Phil!

I gave Bobby some instructions on setting up a trusted location in
another message on this thread

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Guest]

Thanks all for your continuing help. Due to unexpected travelling
requirement we won't be able to try the trusted files till middle of next
week. Will keep you posted on the results.

Bobbysailor
--
Thanks for your support.

Thanks

happy to help

Phil

 

[strive4peace]

Hi Bobby,

safe and happy travels to you!

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Aaron Kempf]

Phil

what you mean to say is this:

a) MS Crippled Access with this crap
b) Excel is a much much much bigger threat
c) jihad against MIcrosoft

 

[Guest]

Hi all, Thanks for all your support and patience. Setting up the trusted
folder solved the problem with opening the databases and exexcuting macros
and the switchboard. There was also a minor problem with a missing
reference that we were able to resove. Access on the developer's pc picked
up a DLL or subroutine from AOL for a control using the date and the target
pc doesn't have AOL. We simply redefined the control on the target pc. Many
thanks for your help!!!

 

[strive4peace]

you're welcome, Bobby happy to help

hope is smoothing "sailing" now <smile>

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*