Copying .mdb file to another computer

[sowen12]

I created a database that has some VB code in it to open a calendar
function. I also have some code that opens Outlook functions (ie.
tasks, contacts, appts). My fellow sales reps saw it and now everyone
wants a copy. I copied to a flash drive and they loaded onto their
computers. One of them is having a problem with the calendar function
- getting "invalid library" error.

Can I just copy this to other users, or does the VB code have
references to my computer that need to be changed for other users?

 

[aaron.kempf]

MDB doesn't support working on a network
you need to move to SQL Server

 

[sowen12]

MDB doesn't support working on a network
you need to move to SQL Server

On May 2, 10:01 am, (e-mail address removed) wrote:

not on a network. this is another user on a standalone pc.



- Show quoted text -

 

[Aaron Kempf]

MDB doesn't work across ANY network

I would reccomend moving to Access Data Projects

 

[sowen12]

Not on a any type of network. I'm simply trying to copy the program
developed to another stand alone computer.

 

[Larry Daugherty]

The message says it all. The MDB refers to a library that it can't
find on the other PC. In order to discover which library it can't
find, open a module on the PC with problems, then click Tools |
References. The dialog box that opens will show the libraries
referenced in your application with check marks. One of them will
have the word "missing". Take careful note of its name - write it on
paper. Uncheck the box associated with it. Close the dialog box.
Still from the module, open the References again. Scroll down in the
list of libraries on your system and (hope to) find it. If you find
it, check it. That should clear the problem. If you don't find it,
you've at least identified the problem.

p.s. Aaron Kempf frequently jumps into a discussion and tries to
create confusion. He's earned a place on most people's Bozo list

HTH

 

[sowen12]

Thanks so much. I knew there was a piece that I was missing, but
couldn't put my finger on it.

 

[John W. Vinson]

I created a database that has some VB code in it to open a calendar
function. I also have some code that opens Outlook functions (ie.
tasks, contacts, appts). My fellow sales reps saw it and now everyone
wants a copy. I copied to a flash drive and they loaded onto their
computers. One of them is having a problem with the calendar function
- getting "invalid library" error.

Can I just copy this to other users, or does the VB code have
references to my computer that need to be changed for other users?

If your code references a .DLL file that exists only on your computer, it will
of course not work. Try opening the VBA editor and looking at Tools...
References on this user's computer and see if there is a reference marked
MISSING; and/or check that the user has the same version of the calendar
function loaded. You may need to install some software or register a DLL file
so that Access can recognize it.

John W. Vinson [MVP]

 

[aaron.kempf]

Larry

what I'm saying is that you MDB jackasses constantly blame stuff on
'the network'

and I grew sick and tired of that scapegoat a decade ago

if you kids weren't fat and lazy you'd be using Access Data Projects