ODBC basics

[RADM]

Hi,

I've just planned to start ODBC concept to access my user-level secured database. But I don't know how to start means what type ODBC should be used like File DSN, System DSN or User DSN. Presently I am using a system database to protect certain databases. Actually I want to access certain tables from an unsecured database. Can anybody help me what type of DSN should be used and how to make connection using my userid and password from system database by using VBA?

Regards,

RADM

 

[LittleSmudge]

You cannot use ODBC between an Access FE and an Access BE - You don't need to - you can just link directly.

ODBC is for linking to 'other' database types.






G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[RADM]

Hi,

So far I didn't split the database. Actually I want to update my database which uses a workgroup file. Is there any way to use the tables in this database from another database by mentioning the workgroup file witht the help of DAO? Please help me.

RADM

 

[LittleSmudge]

Yes you can - but ..

You can simply split the database into a Front End and a Back End and secure both using the same security.mdw file

Then LINK the front end to the back end by :-
In the Front end database window select from the File menu, Get External Data>, Link Tables...

Secure Database and Tables in the BackEnd file and secure Database and Queries, Forms, Reports in the FrontEnd file.


You then don't need ODBC or DAO.


You you do want to go through DAO then you'll need to extract the connection string from the back end in order to insert it into the DAO connection object in the front then code.



'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.