I need to connect to a secured Access 2000 mdb from another program front end

E

Edwin Hannan

Hi All

I am new to the Access Newsgroup so hope you all dont mind me posting an
access related question:)

I use the following dsnLess connection string to connect to a access 2000
mdb
that is not secured. (I use Clarion as a Front End)..this connects me to the
mdb no problem.

I have a varaible AccessDBsource in the owner field of the table in my Table
Definition

AccessDBsource = 'DRIVER={{Microsoft Access Driver (*.mdb)}' |
& ';DBQ=YourMdbFile' |
& ';UID=admin' |
& ';PWD=YourPasswordIfAny' |
& ';ImplicitCommitSync=Yes' |
& ';UserCommitSync=Yes' |
& ';ExtendedAnsiSql=1' |
& ';Threads=4' |
& ';PageTimeout=5' |
& ';MaxScanRows=8' |
& ';MaxBufferSize=2048' |
& ';FIL=MS Access'

I know the name and location of the Secured.mdw that holds the workgroup
info (users and passwords etc...) and I know all the passwords etc...

The actual mdb does not have a password, so access must be via authorised
uid and pw as per the Secured.mdw

What do I add to the connection string to get me in?

cheers

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple PC accessing Front end asp/ web pages to Access Databas 2
Excel Query of Access Q 0
need to run another access program from a front-end 3
Access Front-End to SQL Server 2
Access 2003 Front end SQL Server 2000 Back end via ODBC 0
Mail Merge from Access with datasource being a password protected 2
Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End 7
why can't I access a linked table, when a local table works fine? 9

Top