Posted to microsoft.public.excel.programming

ALEX

external usenet poster

Posts: 493

Extracting data from Access Database password protected

I've manage to extract the data from a database into excel, however now the
database is password protected. How can incorporate the password into the
code I have now. I know the code should go somewhere in this area. Thanks
for any help

Set DB1 =
DBEngine.Workspaces(0).OpenDatabase("s:\Cio\Techpl an\Adams\Itdmgmt\A_Proj_Mgmt_Rpt\Reporting\Access Databases\Dai_ITMB Access2000.mdb")
Set RS1 = DB1.OpenRecordset("tblFTSAtrakHrs", dbOpenTable)

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
I have password protected and now cannot access it...Help	sean_pears	Excel Programming	0	August 14th 06 09:55 AM
How to import data from a password protected Access DB into Excel.	Agus	Excel Discussion (Misc queries)	0	October 12th 05 05:42 PM
Open password protected database	Torsten Hannerfeldt	Excel Programming	2	October 29th 04 09:02 AM
Open Access database(DAO) with password protected	Yanto	Excel Programming	1	April 22nd 04 11:40 AM
open Access DB that is password protected	Shin[_2_]	Excel Programming	1	November 20th 03 12:41 PM

All times are GMT +1. The time now is 01:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us