sunshine076
Registered User.
- Local time
- Today, 12:24
- Joined
- Apr 6, 2009
- Messages
- 160
How do I connect to an Access 2003 database in read only to a switchboard form?
[/SIZE]
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.
Code:
[SIZE=2]Con = [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]New[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] OleDbConnection[/SIZE]
[SIZE=2]Con.ConnectionString = [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] & DBA & [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]";User ID=Admin;Password=suntime8,true"[/COLOR][/SIZE]
[/COLOR][/SIZE][SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]' Dim Con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\Mainsrv\quality\Moeller Training\Training Matrix\MMC Training.mdb")[/COLOR][/SIZE]
[/COLOR][/SIZE][SIZE=2]Con.Open()[/SIZE]
[SIZE=2]Con.Close()[/SIZE]
[SIZE=2]
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.