Can two people enter in the same database at the same time?

[punter]

Hi,

I was wondering if two can people can enter into the same database at the same time? What pitfalls do I need to look out for if it is possible?

Thanks

Eddie.

 

[rainman89]

If you have your database split FE/BE with each user having their own FE then yes. otherwise you may run into problems with a user having it open exclusively and one having it open read-only.
I know before i split my db that was a major concern that i had. until i did some research on spliting my database ( on the forum of course)! found all the infromation i needed to split and run perfectly

 

[punter]

Thank you for your quick reply.

I will do some looking here and see what I can find. I don't know what it means to split a database but that is why I asked. At least now I have a direction to go in.

What are FE and BE?

Thanks

Eddie.

 

[rainman89]

Front End and Back end
the front end has all the forms queries etc.. while the backend stores all the data.
this is clutch when it comes to protecting your data from the user!!

 

[RuralGuy]

Split your Access database into data and application
Splitting your Microsoft Access MDB into a front end and back end

 

[punter]

Thanks Rural Guy. I was about to start looking at this in about 30 minutes. You no doubt saved me a lot of time.

Eddie.

 

[RuralGuy]

Glad to help Eddie,
Those were off forum links. There are others right here on the forum if you use the search feature.