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!

Signature
Business Systems Analyst
Douglas J. Steele - 06 Jun 2006 23:00 GMT
Are you saying you haven't already split the database?
Try using CurrentProject.Connection

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> 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
[quoted text clipped - 14 lines]
>
> *Thanks so much for any help!
Rita - 07 Jun 2006 09:04 GMT
Yes, that is correct.The db is not split (yet). I'll give your suggestion a
try.
Thanks

Signature
Business Systems Analyst
> Are you saying you haven't already split the database?
>
[quoted text clipped - 18 lines]
> >
> > *Thanks so much for any help!
Douglas J. Steele - 07 Jun 2006 22:48 GMT
I'd strongly recommend splitting it now, not later, since your code
obviously will vary once it's split.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Yes, that is correct.The db is not split (yet). I'll give your suggestion
> a
[quoted text clipped - 30 lines]
>> >
>> > *Thanks so much for any help!