[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 987
  • Last Modified:

What is the ADODB connection string to open readonly DB?

Hi ya'll,
    What is the connection string to open a readonly access                       database?

Here is my connection string:
dim db as ADODB.Connection

db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" &
App.Path & "Dbs\test.mdb;Jet OLEDB:Database Password=testdb99;"

Where do I specify that the DB is to open as readonly in the string above?
Thanks,
Steve.

0
stephenhoang
Asked:
stephenhoang
  • 2
1 Solution
 
crazymanCommented:
;Mode=Read
0
 
crazymanCommented:
damn
try this
                                           db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & mdb";Mode=Read;Jet OLEDB:Database Password=testdb99;"
0
 
stephenhoangAuthor Commented:
Thanks a bunch. It worked !!! :)
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now