need help

[Anon]

we have a database on our site; users of the site can add info to the database via a form. They can add 1 series of data or record but when they go to add another, it says that it is accepting the data, but won't save the data in the database until they log out and then log back in to the site. What could be causing this?

[Anon]

Sounds to me like the database needs to be split so that there is a front and back end!

That way when the person enters the data into the front end, it is saved into the table and updates immediately! I think!!!

[Anon]

Can you elaborate on that a little bit?

[Anon]

In the addins, their is a database splitter! This spit your database into two, so that the tables are at one end and your enduser front is another!

This is handy for multi user databases beacuse it means the administratior can work on the front end while people are still adding information. It also means that when information is put in, it automatically updates on everyones front end. Hope this explains it better!

This is what help says about it:

Split an existing database between its data and its objects

This procedure splits a database into two files: one that contains the tables and one that contains the queries, forms, reports, macros, and modules. This way, users who need to access the data can customize their own forms, reports, and other objects while maintaining a single source of data on the network.

Megan

[Anon]

hmmm. our database is hosted by an isp. wonder if they will enable this for us. something to look at anyway.

seems kind of odd that you could enter one record and not another tho, it should be noted that there is nothing else going on with the database at the same time. You just can't enter more than 1 record into the database without logging off and then back on.

Thanks for your suggestion though, well definitely look into splitting the db. seems better that way.