how to make new changes to a file

[ariansman]

I have created a copy of an access file to make some changes to tables, forms and etc. Some of them are deleted, new ones created or the codes are changed.
Is there a way that I can apply all the changes to the original file?
Thank you

 

[gemma-the-husky]

I assume you haven't split the data in the orginal database, which menas you want the new code to apply to the existing data

if you split the database, then you can just replace the front end. The easiest way is to split the original database, and the new one, and then replace the old front end with your new one.

 

[ariansman]

i am not sure that i know what the word "split" means here.
well, i have made new forms and queries in the copy file. the i put some data to run tests and make sure they are working. as a result the data in the copy file is not the same as original one.

 

[gemma-the-husky]

A "split" database is actually two databases

one (the backend) holds the data tables

the second(the frontend) holds the programming logic,. forms/queries/reports/modules etc

each user has a separate front end, and all front ends are linked to a single backend. this is the best way of having a multi user database. It is much better than the alternative (dangerous) solution of all users opening the same network single copy of the database.

There are some very minor differences between operation of a split databases, and a single unsplit database.

By doing it this way, you can change the programme functions in the front end, independently of the back end - which I presume is the problem you are having.