Compact User-Level Security Database in ADO

[Tim]

Hi folks,

I have two Access XP (2002) database called TestA.mdb and TestB.mdb.
TestB.mdb is a user-level security database. I want to build a module in
TestA.mdb to compact TestB.mdb. Could anyone tell me how to do it by using
ADO?

Any help will be appreciated.

Thanks in advance.

Tim.

 

[Douglas J. Steele]

http://support.microsoft.com/?id=230501

If you need other connection strings, check Carl Prothman's
http://www.able-consulting.com/ado_conn.htm

 

[Tim]

Hi Douglas,

The site "http://support.microsoft.com/?id=230501" looks like for password
protected database. My TestB.mdb is a user-level security database which has
user ID: test1, password: test1 and testBGroup.mdw. Do you know how to
compact it in ADO?

Thanks in advance.

Tim.

 

[Douglas J. Steele]

I take it, then, that you didn't go to Carl's site to get the appropriate
connect string for secured databases as I suggested you do if the KB article
wasn't the string you needed.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

I should admit now that I never use ADO (or, more accurately, JRO) to
compact databases, so I have no experience with this approach.