Can I delete tables via VBA code in a Runtime environment?

[stildawn]

Hi All



I am close to finishing a new database. In this database I have some VBA code that does a bunch of stuff, one of those things is to check if a temp table exists, and if yes then it will delete it.

Once finished this database will be made available to a range of people via Access Runtime 2010. I'm just wondering will the VBA code that deletes a table work in a Runtime environment?

I guess I should also ask if a save import process will also run via Runtime.

Its not a biggy, just need to make sure that the users that need to do this code have full access if its required.

Thanks

[ItsMe]

I believe it will. One way to check is to create a copy of your DB. Change the extension to accdr.

If there is not an exception, I would think it is working.

The final test would be to use a machine that does not have a full version installed. I have yet to discover something that worked as accdr but did not as ACCDE

[alansidman]

I have created code for an accdr file and it ran without issue. The user cannot access the code, but it should still run.

[stildawn]

Excellent, thanks guys, I was wondering cause the limitation of Runtime was that the user couldnt design stuff, thought that might extend to deleting/importing tables.

[ItsMe]

It is a good question. There is a difference between Design Time and Run Time. If you write VBA that will not work in Run Time because it depends on Design Time, you will get a Run Time exception.

Testing is necessary.