Open Access DB from VB.Net Logon form

videocorner
03-03-2004, 09:36 AM
I am trying to figure out how to use a VB.Net logon form to validate the password then, open the Access Application with read only access if the user doesn't have write access.

I don't have a problem opening the database, I just can't figure out how to open it in readonly mode so they can't change my data. Any thoughts?

Tim

Wamphyri
03-04-2004, 07:22 AM
Let's see who you are opening the db

videocorner
03-04-2004, 07:51 AM
I assume you meant how was I opening the DB

Code Sample:

'Declare the variable
Dim objAccess as new Access.Application

'Call the database
objAccess.opencurrentDatabase("D:\test.mdb")
objAccess.visible =true

Perhaps this isn't the best way to open the DB but is the only way I know how. Any suggestions otherwise will be appreciated.

Tim

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum