Accessing Database From Front End

[Tsango]

Hi there

I have an application that I run in our business.

Everytime I make changes to the code I have to export all the tables from the original into the latest version of the database with the new code.

This is a pain and makes updates time consumming and prone to error.

Is the soloution to have 2 databases. One with the tables and the other with the code (forms), & reports ect

If so, how do I access tables in the 'tables' database from the 'front end' database??

Thanks in advance

OLiver

 

[Bigmo2u]

You need a FE/BE. Go into your current DB that you got and goto Tool>Database Utilities>Database Splitter. It will do it for you and now you have a FE with your forms that automatically links your tables in the BE.

I hope this helps and is what you are looking for.

 

[Tsango]

Thanks very much - That is just what I required...

 

[cross5900]

Should also look into setting it up with an auto-update feature for everytime you make a new version or update, which is pretty time consuming but when you get it, you can use it in all your future databases and it makes updating so much each