ACCESS FEED: Re: [MS_AccessPros] printing to a text file over VPN

Sabtu, 01 Maret 2014

Re: [MS_AccessPros] printing to a text file over VPN - split database

John-

In another post you said:

i am using a network location \\main\Vol1\shared\...

When you're on VPN, can you access that share and write to it?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Mar 1, 2014, at 10:41 PM, John Heinze <shelbysalpha@yahoo.com> wrote:

It works fine at work. Only when i try it with VPN is there a problem.

."The only real mistake is the one from which we learn nothing."
       John Powell (1834-1902)
"Patience is the companion of wisdom."
        Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
               to another with no loss of enthusiasm."
       Sir Winston Churchill (1874 - 1965)

From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Saturday, March 1, 2014 2:18 PM
Subject: RE: [MS_AccessPros] printing to a text file over VPN - split database

Do you even have permission to write to the root of your C drive? Have you first attempted to do this manually prior to attempting in code? I can't write to C:\ on my computer.

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: shelbysalpha@yahoo.com
Date: Sat, 1 Mar 2014 11:14:17 -0800
Subject: Re: [MS_AccessPros] printing to a text file over VPN - split database

neither slash makes any difference over the VPN

."The only real mistake is the one from which we learn nothing."
       John Powell (1834-1902)
"Patience is the companion of wisdom."
        Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
               to another with no loss of enthusiasm."
       Sir Winston Churchill (1874 - 1965)

From: John Viescas <JohnV@msn.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, March 1, 2014 2:52 AM
Subject: Re: [MS_AccessPros] printing to a text file over VPN - split database

John-

You need a back slash in the address

Open "C:\ListIPAllocation.txt" For Output As #1

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Mar 1, 2014, at 1:05 AM, John Heinze <shelbysalpha@yahoo.com> wrote:

Open "C:/ListIPAllocation.txt" For Output As #1
this is failing with error: Bad file name or number.
can i specify that i want to print this file on the front end computer not the back end computer?

."The only real mistake is the one from which we learn nothing."
       John Powell (1834-1902)
"Patience is the companion of wisdom."
        Saint Augustine (354 AD - 430 AD)
"Success is the ability to go from one failure
               to another with no loss of enthusiasm."
       Sir Winston Churchill (1874 - 1965)