Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / June 2006

Tip: Looking for answers? Try searching our database.

Connections in ADO

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rita - 06 Jun 2006 20:12 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.