mde file access

[zqi]

Hi,

We have Access 2000 .mde file installed on user's machine. There is a local table, tblTABLE, in each of these mde files. Is that possible for me to access this tblTABLE from outside and grab/export the record (only one) values?

Thanks in advance.

 

[LittleSmudge]

Yes - if it is just an MDE and there's not a lot of other protection around it too.

Create a new Access database ( .mdb ) or open an existing one in design view.
From the File menu select Get External Data and choose Link Tables ...

Then navigate the dialog box to the .mde and click Link.

You'll then see a list of the tables in the .mde and you can link to it.

That will put a linked table into your database which can be opened read ( and written to ) .


'ope-that-'elps.



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

 

[zqi]

Thanks LS,

Actually, what i like to do is to access this MDE file from other programming tool, like ASP.NET, to retrieve the local table values. Yes, you are right, shouldn't be in this VBA Forum. But...

zqi