Locking a selected record

[Burt Rosner]

Need help,

Need to know how to lock a record in a MS Access table
when I am creating an edit page using the Front Page
Wizard (2002). I know I can use LockPessimitic when I
call a record, but can't find this parameter in the wizard.

Thanks, in advance, for your help,

Burt

 

[Tom Gahagan]

Hi Burt.....

I've not use the database wizard before so I'm not sure about using it....
but you can do it using ADO and asp...... perhaps more than you want or have
time to do!

Anyway...... several sites have example code you can look at and learn from
here are a couple of links and after that are some MSDN article links that
might help. I'm sure that others with have additional help for you!

Best to you....
Tom Gahagan

for example code.... www.planet-source-code.com www.hotscripts.com

some articles ...... ( also you can go to the MS web site and find lots of
stuff.... that is where these links are from.)

Locking Shared Data by Using Recordset Objects in VBA (Microsoft Office
2000/Visual Basic Programmer's Guide)

Microsoft ActiveX Data Objects (ADO) Programming

What's New for Microsoft Access 2000 Developers (Microsoft Access 2000
Technical Articles)

Understanding Microsoft Jet Locking

 

[Burt Rosner]

Tom,

Thanks for the info.

Burt

-----Original Message-----

Hi Burt.....

I've not use the database wizard before so I'm not sure about using it....
but you can do it using ADO and asp...... perhaps more than you want or have
time to do!

Anyway...... several sites have example code you can look at and learn from
here are a couple of links and after that are some MSDN article links that
might help. I'm sure that others with have additional help for you!

Best to you....
Tom Gahagan

for example code.... www.planet-source-code.com www.hotscripts.com

some articles ...... ( also you can go to the MS web site and find lots of
stuff.... that is where these links are from.)

Locking Shared Data by Using Recordset Objects in VBA (Microsoft Office
2000/Visual Basic Programmer's Guide)

Microsoft ActiveX Data Objects (ADO) Programming

What's New for Microsoft Access 2000 Developers (Microsoft Access 2000
Technical Articles)

Understanding Microsoft Jet Locking







.