mounting a drive from Access

[MilaK]

Hello,

The back end of my Access database will be located on a shared drive L:. I execute a bat file to mount the L: drive each time I log into my PC.

Here is what the bat file says:

mount -o fileaccess=775 10.20.219.75:/data L:

pause

end

Is it possible to map this drive via Access's front end when the user opens the front end file? Could someone please suggest some code that would do the trick?

thank you

 

[Uncle Gizmo]

Use the bat file to open Access..

 

[MilaK]

Could you please suggest how to execute the bat file and also input any key that is required by the bat file?

Also, where should the code fire from?

Thank you?

 

[The_Doc_Man]

Uncle G wasn't telling you to launch the bat file from Access. He was telling you to launch Access by launching the bat file that contains the MAP operation AND a line to launch MSACCESS.EXE as a second action within the file.

If you have a back-end file on your L drive and the L drive is not mapped correctly, you will never get to the point of executing the code that would perform the mapping. This is because the Access "initialization" routines would detect that the local disk setup is not right and therefore would block the launch. In essence, your code within Access to DO the mapping would never get executed unless the mapping had already been done.

 

[MilaK]

That's a good idea.