Re: Print over a network

Thanks JoeO very helpful

"JoeO" wrote:

> 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: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • RE: Sharing data between distributed apps
    ... the other computers immediatly? ... computer (on the same network) must retrieve that name and show it to the ... In your program connect to that database using ADO.Net ... > Server and understand them well enough. ...
    (microsoft.public.dotnet.distributed_apps)
  • Problem: Network programming, OpenWorkspace?
    ... I built a small MS-Access database program which has the topics as ... I want to make a program which resides locally in a shared location on ... each of the user's computers, and feeds to a database local to the ... itself, not in the network. ...
    (comp.databases.ms-access)
  • Re: Physical Computer Location
    ... These computers are on a network, so presumably they have network cards. ... Keep a record of the MAC address, associated in a database with the ... Modeled after the famous Black Hat event in ...
    (Security-Basics)
  • 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)