accessing Global variables

[Domac]

Hi,

I would like to access global variable declared in my backend database, is
it possible??

I have just solved transaction between accounting application based on Sql
server 2000 database and manufacturing managment solution (wich i have
developed).

Problem is that every user is running transaction code , so in that critical
moment , it is possible to make duplicates.

My solution is to set variable value (in back-end database that everyone
access) to value 1 wich means that transaction is in progress.
I want to aviod creating table in back-end database ( because simple boolean
would do the job) just for one variable.

Thanks a lot!
Domagoj

 

[Pieter Wijnen]

You should solve this by using transactions & locking mechanisms in stead
Youy can use the dbDenyWrite option constant for a DAO Recordset ,
DAO.QueryDef.Execute Or DAO.Database.Execute
methods to deny other users to do updates simulatously, but the *correct*
way should always be to use transactions

ie

Dim Rs As DAO.Recordset

Set Rs = Db.OpenRecordset("MyTable",DAO.DbOpenDynaset,DAO.dbSeeChanges +
DAO.dbDenyWrite)
Will prevent others to update MyTable as long as the recordset is open


HTH

Pieter

Hi,

I would like to access global variable declared in my backend database, is
it possible??

I have just solved transaction between accounting application based on
Sql server 2000 database and manufacturing managment solution (wich i have
developed).

Problem is that every user is running transaction code , so in that
critical moment , it is possible to make duplicates.

My solution is to set variable value (in back-end database that everyone
access) to value 1 wich means that transaction is in progress.
I want to aviod creating table in back-end database ( because simple
boolean would do the job) just for one variable.

Thanks a lot!
Domagoj

--