[AccessD] Leave a bound form in a library.

Shamil,

I take it you mean linking the tables from the FE back into the lib so that the form opens seeing 
the security info for the FE.

I did something like this but ended up with problems when the client wanted to use the library for 
two different FEs which needed different security info.

John W. Colby
www.ColbyConsulting.com


Shamil Salakhetdinov wrote:
> Hi John --
> 
> What about linked tables?
> I used them in library MS Access databases and that worked well for me and
> for my customers in many projects.
> 
> Thank you.
> 
> -- Shamil
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Wednesday, September 01, 2010 5:38 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Leave a bound form in a library.
> 
> One of the challenges of using an "addin" library is placing forms in the
> add-in but having them 
> load records from the FE.  For example if I make a bound form to load the
> users table but I leave 
> that form in the library (add-in), then when the form opens it tries to load
> the data from the table 
> in the library.  IOW a form tries to pull its data from whatever container
> it is placed in.
> 
> One way around that is to use the "in 'MyFePath\MyDbName.mdb' syntax that is
> valid in access.  As an 
> example SQL to pull the records from the FE might look as follows:
> 
> SELECT * FROM usystblPLSObjFrm in 'C:\Dev\C2DbPLS\C2DbPLS.mda' ORDER BY
> PLSF_Name;
> 
> This would obviously pull all fields from the table usystblPLSObjFrm
> physically located in 
> C:\Dev\C2DbPLS\C2DbPLS.mda.
> 
> This is a PITA and requires jumping through hoops but that is the only
> solution that I know of.
> 
> If any of you know of another solution please let me know since I do have to
> get adept at hoop 
> jumping to do it my way.
> 
> Thanks,