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.
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.