Self-building database

[Epic]

Hi All,

I am working on an Access database (2000) which will be used by many users. My question is if is possible to build/create forms and queries using visual basic and storing the source in a table.

Thanks.

 

[Ron_dK]

Take a look at this :
http://www.access-programmers.co.uk/forums/showthread.php?t=78647&highlight=Front+end+Back

If that doesn't help , do a search in this forum with "front end back end".
There is loads of stuff in this issue.

Good luck

 

[Epic]

Thanks RAK,

I found useful information but because this database will be used outside our network and to save time I would like to replace only the altered form or query. I am thinking on using an FTP to copy the whole DB (I know how to do that) but re-building the changed form or query based on the script stored in a table using access vb (if is possible) looks more elegant to me.

This DB uses ODBC connection to an SQL Server and some settings are stored in local tables. I don't want to lose them.

Any advise? Can I convert a form/query to usable vb code?

Thanks.

 

[cable]

query's and tables you can 'create' from a suitable script, I've done this before.

forms, reports and modules I don't think so, so you would have to create an 'update' db that contains the new objects, and then a script could import these across accordingly.

It would be a lot of coding and testing to make sure it all works, but the concepts not difficult at all.

 

[ghudson]

This thread might give you another idea on how to update the db objects...

Export All Database Objects Into Text Files