Rabu, 26 Februari 2014

RE: [MS_AccessPros] RE: Splitting access 2010 database

 

Off topic: 

 

LOVE the quotes.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Heinze
Sent: Tuesday, February 25, 2014 2:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: Splitting access 2010 database

 




How do I get my front end trusted? I am not using seek. I am using a for next loop to "look" at each record.

 

."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: Tuesday, February 25, 2014 2:50 PM
Subject: Re: [MS_AccessPros] RE: Splitting access 2010 database

 

 

Also, if you were using Seek on your recordset when they were local tables, that won't work with linked tables because any recordset opened on a linked table is always a Dynaset recordset, not a table recordset.

 

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 

(Paris, France)

 

 

 

On Feb 25, 2014, at 9:49 PM, <wrmosca@comcast.net> <wrmosca@comcast.net> wrote:



Your VBA code will not work unless the front end is in a trusted location. The network settings have nothing to do with whether or not the VBA code will run as long as you have read/write/create/delete permissions on the back end folder.

 

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote:

I have a database with VBA code searching through and listing records. Works great! Then I split the database and the VBA code quit working. Any ideas? Network settings? Path to back end? 

 

."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)

 

 






This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)
.

__,_._,___

Tidak ada komentar:

Posting Komentar