Alter permissions to an external mdb

[feets]

I am creating a system that logs visits to site, using a sql backend, access front end. Now loading the front end I have a procedure which creates a local mdb file in the users my documents folder. The purpose of the local mdb file is that it gives the user an offline record of all their visits.

When there are design changes which involve additional tables adding to the local mdb, I want to run on startup a sql query to check whether table exists in the local mdb. So I do a Select Query of MSysObjects where name='tblname'.

However when I load up the front end I get an error saying Record cannot be read, no read permission of MsysObject. Now I can obviously go into the VB Created Mdb and alter the permissions. However that is no good when I need to distribute to 100 workstations.

What I need is, VB code to alter the permissions on the MsysObject, when I create the Local Mdb.

Any Idea's??

 

[Guus2005]

Try this:

SELECT *
FROM Supplier IN '\\uncpathtouser\MyDocuments\UserDatabase.mdb'
WHERE 1=0;

Gives you zero records and no error message when the table exists.
Gives you an error message when it doesn't.

What i usually do is i create a PARAM table which has a database version number. When it is not up to date i adjust the database and update the version number.

HTH