How do I connect to an Access 2003 database in read only to a switchboard form?

Con = New OleDbConnection
Con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBA & ";User ID=Admin;Password=suntime8,true"
' Dim Con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\Mainsrv\quality\Moeller Training\Training Matrix\MMC Training.mdb")
Con.Open()
Con.Close()


It errors saying that password is invalid and once I get that working it says that someone has it open exclusively. I have a main person who will modify the database behind the scenes while others should only be able to view as a read-only file.

G'd evening Sunshine,
I'm not aware that the read only mode can be set at connection level. You may use the workgroup security, the windows explorer security, a protected form, etc.
To avoid the "open exclusively" issue split your db (FE and BE) so you redistribute localy the FE.
G'd luck