Question Multiple database users at the same time.

[Jason1]

hello,

I am currently running a database using access 2007. The database is only used on two computers, and the access file (the whole database) is stored on a server. The database us accessed simply by opening it from a shared doc location. In other words the database is not split. I plan to split the database, but it is in the very early stages of operation.

We are using the database to store manufacturing data. The data is entered on the factory floor regularly during the course of a day.

As with any start-up database, there are changes that need to be made. I would like to be able to work on the database (design, and debug) from one computer while the database is still in operation on the factory floor.

How would the database professionals on here (i'm a rookie) handle this situation?

Thanks

 

[Galaxiom]

You must split the database. This separates the data (BackEnd) from the application (Front End) and allows developemt to continue.

You should also have a test BE so that you don't damage the data if you make a mistake in development.

 

[Jason1]

Thanks for the quick reply. I am assuming by BE you mean back end. That all makes sense now that I think about it. Where would I go to learn the correct way to split the database?

I am assuming I put all of the tables, queries and reports on the server, and use the forms to call those files? Is that correct?