Re: Print over a network

All computers (in your LAN) having their ODBC settings (pointing) to a
common datatabase should easily share the same database. Though you must
look at record/database locking issues if you haven't. You don't want to
open a database exclusively when other users are also expected to connect to
the same db. If your data requires that no two users have access to the same
record at the same time then you must lock the record when opened by a user.
Look at Begin/Commit Tran. How about where a user opens a record and forgets
and goes fishing, what should happen? Wait until he/she return from the
fishing trip? Note that MS Access has limit to the number of users that can
connect simultaneously to Access. Expert users say Access gets cranky after
about 8 concurrent connections. Most multiuser issues are problems that the
app designer must anticipate and take of. Connecting to multiuser database
is the easy part.

Printing to a particular printer in LAN is easy. Typically, only systems
with permission (access) to a printer printer on LAN can print to that
printer. You use printer collection to select your desired printer as long
as that printer is in the user's system printer collection.

Dim X As Printer
For Each X In Printers
If X.DeviceName = "MyTargetPrinter" Then
' Set printer as system default.
Set Printer = X
' Stop looking for a printer.
Exit For
End If
Next

'Then print to X



"Opyuse" <Opyuse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33798A8C-52B7-4CD8-8921-488E0641135A@xxxxxxxxxxxxxxxx
> I know nothing about networks and the computer I have to use to write my
> application does not have access to the network that it will be running
on.
>
> So I have the complecated task of making a multi-user application that can
> be used on taht network by more then one person.
>
> So I have two questions
> 1)Is there anything I must have for my vb6 app which uses odbc to conect
to
> a database so it can be used by more then one user?
>
> 2)How do I set up a print option that prints to one printer in the office?
>
> Any help you can give me will be greatly received.


.

Relevant Pages

  • Re: Replication: Alternatives?
    ... > copy of the database. ... > cannot be connected to the LAN. ... If they can *never* be connected to the LAN, replication is ... single point of connection between the LAN and outside the LAN. ...
    (microsoft.public.access.replication)
  • Re: Very slow response
    ... If you open a new Access database, select Tools, Options ... ... has been set to something on the LAN? ... > I entered Access, open the database file ... > Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: Print over a network
    ... > All computers having their ODBC settings to a ... > common datatabase should easily share the same database. ... > Printing to a particular printer in LAN is easy. ... >> be used on taht network by more then one person. ...
    (microsoft.public.vb.general.discussion)
  • DCOM Help (was : RDO Help)
    ... time-consuming megalith of a project is nearing its deadline, and LAN ... (mainly database locking and synchronisation) ... the database engine is also proprietary, ... and deploying a DCOM object, and haven't yet been able to do so. ...
    (comp.lang.basic.visual.misc)
  • Re: User Groups
    ... Knowing about the LAN is the key to getting this to work, Crystal, so if you ... > database just on different computers in the office. ... > "Rick B" wrote: ...
    (microsoft.public.access.modulesdaovba)