Re: Importing from Access XP database with User Level Security

#1

In message <97DD7179-C4ED-4CF8-B8E7-0E29F7E88EB1 (AT) microsoft (DOT) com>, DebbieB
<DebbieB (AT) discussions (DOT) microsoft.com> writes

Quote:

Hi:

I am trying to import data from an Access XP database that has user-level
security implemented against it (ie, it has an .mdw file). Is there a way to
do this? I've been experimenting with including the .mdw file path in the
database name to no avail. Any help would be appreciated.

Thanks!

Manually, just open the Advanced properties, set "Jet OLE DB:System
Database" to the system.mdw file, and "Jet OleDB

atabase Password" to
the password.

How can I dynamically set the Access System Database
(http://www.sqldts.com/default.aspx?241)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Importing from Access XP database with User Level Security

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Importing from Access XP database with User Level Security - 08-25-2004 , 03:16 PM