Replies

Everyone is talking about SQLserver. What is it? Do you have to buy it, or is it delivered with Access 2000? Is it diffucult to use?

About 30-50 users at a time.
What do you think the breakpoint is? 100? 200 users?

Not much data entry at peak-hours.

Thanks for your advise till now yet!

rettnuc.

Parameterquery is not an option because of the reason I want to use that variable in a query:

I use a combobox on a form to select a writer. On that form I have different buttons which open different forms which show information about that writer. Using subforms has come into my mind, but is not what I want.
Therefore I use different queries, having one item in common: writerID. Catching that ID from the main-form is slow, so I want to set a public variable and use that as a criterium in the different queries for the forms.

Q: IS there anyone having bright ideas? Otherwise I’ll stick with the GetVariable function HansV and me mentioned before.

Ofcourse I can use:

Function GetVariable() as variant
GetVariable=(fill in name of variable)
End Function

But isn’t there an easier way to do this?

That’s easy: I want to protect my database from using in another environment, so I want to let a sort of dongle run on the networkserver: a computer only I have access to. The application runs on several machines in the factory. Whenever a user logges on, the application sends a message to the server-application, containing username and user-computer-ID. The server identifies the user and user-machine. The user-application will only continue if idenfication is valid. When failed, the user-application will not run.
The user-application is protected, so users can’t debug my applicaiton, but making a copy and using it at home, or selling it to others can always be done. This way I want to prevent them from successfully doing that!

rettnuc.

http://www.mvps.org/access/general/gen0005.htm%5B/url%5D

Edited by Charlotte to activate link

On the main-form of your dbase, put an on-close event and use a global boolean-variable to check if you really want to quit the form or not. Cancel the on-close event on false.

rettnuc.

right again. and is the case indeed in my real db!

thanks again!

oops. you’re right.

Great! It works!

Thanks!!!