Before posting read this please!

[onedaywhen]

Most of the users are thinking they are ready to use such thing as
Access, Excel and so on. They consider themselves "powerusers" just because
they can type words, add to numbers, and create a field in the DB. And they
a trying to complete tasks and solve problems, which are far beyond their
knowledge, expertise and so on... <snipety snip>

As a 'Master Instructor' you think people shouldn't try to complete
tasks beyond their knowledge/expertise and no one should teach people
how to do simple things? So you only teach genuine 'power users' then?
OK, answer my question:

From: onedaywhen ([email protected])
Subject: Specify .mdw file in embedded connection string
Date: 2004-04-27 06:35:45 PST

I can use the following syntax to select data from another .mdb file:

SELECT * FROM [Database=C:\Tempo\AnotherDB.mdb;].MyTable

alternatively

SELECT * FROM MyTable IN 'C:\Tempo\Another.mdb'

Does anyone know if it's possible to extend this to use workgroup
security i.e. specify a .mdw (system.mdw) file plus userID and
password?

Thanks.

--

 

[jamieuk]

I would say: Hello.
Just for the record:
<shameless advert removed>

But... Let's make END of this Post.

Of all my points, this is the only one you are prepared to respond to?
Presumably the rest is indefensible then.

 

[Tony Toews]

I am infinately appreciative of the MVPs, and their willingness as
a group, to be patient with me and all the other Access newbies. I have
made amazing strides in my abilities as a developer, hoping that it will
become a new vocation for me. Maybe I'll be an MVP myself one day.
I'll tell you, though, without the support of these groups, I'd have
been buried long ago.

Thanks very much for your kind words.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm