Thanks for the offer, but have solved my little problem.
The problem was due to our MIS department define a new workgroup
administrator file. (.mdw).
This caused a problem as it assigned security levels.
To access the database, the following code was used.
resultsTable (Declared) Recordset.
mdb (Declared) Database.
DBENG (Declared) DBEngine.
Set mdb = DBENG.WORKSPACES(0).OpenDatabase(mdbFileSpec,False , False);
Set resultsTable = mdb.OpenRecordSet("qEnduranceTestData",dbOpenDynaset)
Maybe this will help somebody one day!
BHC Components Ltd
20-21 Cumberland Drive
Granby Industrial Estate
Tel: ++44 1305 830734
Fax: ++44 1305 760670
<MikeJWatts@compu To: "INTERNET:firstname.lastname@example.org" <email@example.com>
serve.com> cc: "VEE vrf" <firstname.lastname@example.org>
Subject: [vrf] MS Access problem
Thanks for checking out my website - and for your comments.
I tried a few ideas based on your e-mail but, assuming there is a database
file at c:EnduranceTest.mdb, there is a table called TestDetails and that
you have exclusive rights to the database and table ( i.e. that you can
open them without having to give access to others ) I'm not sure what the
problem is. If you want to mail me an example ( suitably 'sanitised' such
that there is no sensitive data ) I'd be happy to have a quick look to see
if I can replicate the problem you see.
You are currently subscribed to vrf as: email@example.com
To subscribe send a blank email to "firstname.lastname@example.org".
To unsubscribe send a blank email to "email@example.com".
To send messages to this mailing list, email "firstname.lastname@example.org".
If you need help with the mailing list send a message to "email@example.com".