Cross Post 'Security - DAOVBA': Updatiung Secured Back-end in code from Front-end in Runtime environ

K

Kahuna

Sorry for cross post folks - just realised I was probably in the wrong
group!

Hi Folks

I have been using a technique where the front-end checks an update table
that indicates the Fields, Relationships and defaults etc to be updated in
the back-end, and goes ahead and makes the relevant changes.

However, two things have changed:

1. The app is now in runtime and MSAccess is not available

2. The back-end is now user-secured - using RWOP queries to access data.

Questions:

a. Is it possible to update the back-end structure in code in runtime?

b. If so, what techniques do I need to apply to get access to the back-end
tables etc from the Front-end (how to pass a password if necessary or create
a connection)?

c. Is there a better way to organise back-end structural changes on a secure
Db?

Appreciate any feedback.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top