Posted to microsoft.public.excel.programming

kalle

external usenet poster

Posts: 27

Coonect to access with password

Hi.

I use this code to connect to my database at work.

Set con = New ADODB.Connection
con.Provider = "Microsoft.Jet.OLEDB.4.0"
con.Open ThisWorkbook.Path & "\my.mdb"

Now I want to protect the database with a password. But it does't work.
Can anyone help me?

Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
connect to access using password	Patrick Molloy	Excel Programming	1	June 8th 09 12:00 PM
Password Access to certain sheets	Sheryl	Excel Worksheet Functions	2	November 28th 06 09:39 PM
Connect to MS Access with Password via VBA	matelot	Excel Programming	2	September 19th 06 03:55 PM
Add Password Using Access	Ross	Excel Programming	1	September 8th 05 07:11 PM
access password	Capt.Scott	Excel Programming	1	January 7th 05 06:41 PM

All times are GMT +1. The time now is 07:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us