Group:  Microsoft Access ยป microsoft.public.access.multiuser
Thread: Connections in ADO

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Connections in ADO
Rita 06.06.2006 19:12:01
Hi, I need help with setting up a 'dummy' connection. I'm developing an
application that will be used by a field of remote users eventually, I have a
parameter query setup in a class module that I want to test, however it is
looking for the connection criteria. The app is currently set up as single
user, so there is no database other than the one I am currently working in to
connect to. The form will not run of course, because it cannot find the
object. I just need a way to get around this temporarily while this is being
tested in house. The form is a simple login/password screen that checks a
table to verify login id and pass are correct, it allows users to change
passwords as well. Users in the field are currently in Access 2000, each
local to their systems, app is being developed in 2003 and will reside on a
network.

*Thanks so much for any help!

--
Business Systems Analyst
Re: Connections in ADO
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 06.06.2006 22:00:51
Are you saying you haven't already split the database?

Try using CurrentProject.Connection

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rita" <Rita[ at ]discussions.microsoft.com> wrote in message
news:8ED8E54C-E79E-4C15-9DA3-8E00441ADE76[ at ]microsoft.com...
[Quoted Text]
> Hi, I need help with setting up a 'dummy' connection. I'm developing an
> application that will be used by a field of remote users eventually, I
> have a
> parameter query setup in a class module that I want to test, however it is
> looking for the connection criteria. The app is currently set up as single
> user, so there is no database other than the one I am currently working in
> to
> connect to. The form will not run of course, because it cannot find the
> object. I just need a way to get around this temporarily while this is
> being
> tested in house. The form is a simple login/password screen that checks a
> table to verify login id and pass are correct, it allows users to change
> passwords as well. Users in the field are currently in Access 2000, each
> local to their systems, app is being developed in 2003 and will reside on
> a
> network.
>
> *Thanks so much for any help!
>
> --
> Business Systems Analyst


Re: Connections in ADO
Rita 07.06.2006 08:04:01
Yes, that is correct.The db is not split (yet). I'll give your suggestion a
try.
Thanks

--
Business Systems Analyst


"Douglas J. Steele" wrote:

[Quoted Text]
> Are you saying you haven't already split the database?
>
> Try using CurrentProject.Connection
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Rita" <Rita[ at ]discussions.microsoft.com> wrote in message
> news:8ED8E54C-E79E-4C15-9DA3-8E00441ADE76[ at ]microsoft.com...
> > Hi, I need help with setting up a 'dummy' connection. I'm developing an
> > application that will be used by a field of remote users eventually, I
> > have a
> > parameter query setup in a class module that I want to test, however it is
> > looking for the connection criteria. The app is currently set up as single
> > user, so there is no database other than the one I am currently working in
> > to
> > connect to. The form will not run of course, because it cannot find the
> > object. I just need a way to get around this temporarily while this is
> > being
> > tested in house. The form is a simple login/password screen that checks a
> > table to verify login id and pass are correct, it allows users to change
> > passwords as well. Users in the field are currently in Access 2000, each
> > local to their systems, app is being developed in 2003 and will reside on
> > a
> > network.
> >
> > *Thanks so much for any help!
> >
> > --
> > Business Systems Analyst
>
>
>
Re: Connections in ADO
"Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 07.06.2006 21:48:01
I'd strongly recommend splitting it now, not later, since your code
obviously will vary once it's split.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Rita" <Rita[ at ]discussions.microsoft.com> wrote in message
news:3D8E55AB-16EE-4F51-95B9-FD8ADBB9D9D0[ at ]microsoft.com...
[Quoted Text]
> Yes, that is correct.The db is not split (yet). I'll give your suggestion
> a
> try.
> Thanks
>
> --
> Business Systems Analyst
>
>
> "Douglas J. Steele" wrote:
>
>> Are you saying you haven't already split the database?
>>
>> Try using CurrentProject.Connection
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Rita" <Rita[ at ]discussions.microsoft.com> wrote in message
>> news:8ED8E54C-E79E-4C15-9DA3-8E00441ADE76[ at ]microsoft.com...
>> > Hi, I need help with setting up a 'dummy' connection. I'm developing an
>> > application that will be used by a field of remote users eventually, I
>> > have a
>> > parameter query setup in a class module that I want to test, however it
>> > is
>> > looking for the connection criteria. The app is currently set up as
>> > single
>> > user, so there is no database other than the one I am currently working
>> > in
>> > to
>> > connect to. The form will not run of course, because it cannot find the
>> > object. I just need a way to get around this temporarily while this is
>> > being
>> > tested in house. The form is a simple login/password screen that checks
>> > a
>> > table to verify login id and pass are correct, it allows users to
>> > change
>> > passwords as well. Users in the field are currently in Access 2000,
>> > each
>> > local to their systems, app is being developed in 2003 and will reside
>> > on
>> > a
>> > network.
>> >
>> > *Thanks so much for any help!
>> >
>> > --
>> > Business Systems Analyst
>>
>>
>>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net