Hi, need some help here...

I am currently doing up a MS Access tool. (Coding in the VBA environment in MS Access)

Currently, I have 2 MS Access Database file (File1.mdb and File2.mdb).

From File1.mdb, I need to connect to File2.mdb to extract certain data (in Table2).
An ODBC Link using Data Source Name was set up and I used the following codes (in a form from File1.mdb)

================================================== ===
1 dim con as new adodb.connection
2 dim rec as new adodb.recordset

3 con.Open "DSN=TABLE_REQUIRED"
4 rec.Open "SELECT * FROM data", con, adOpenDynamic, adLockReadOnly

================================================== ===

I have no problems getting the connection up, but I keep getting the following error message which is not allowing me to open the recordset that I need:

[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'data'.

I have alread enable all access rights for all user to File2.mdb
Hence, I am not sure why I still can't get the recordset opened!

Any help is greatly appreciated!



Scripts82

__________________
Scripts82

Try passing the username and password for the second database, if there is one. It sounds like you have either Access security, or some network security running. Access security will take a username and password, but I am not sore how to pass it to network security.

Is the second database set to read-only through its network properties dialog box? Is it in a secure folder, etc?

You might also consider linking the databases by using the Insert > Table > Link Table wizard, and then just referring to the second database table as a local table.

HTH


mmcdonal

Thanks mmcdonal...
You are right about the access security thingy...
Somehow, after rebuilding the database on a fresh mdb file, the problem was solved...

Scripts82