Frontend and backend DB

[Sed]

Please help,
I have access DB that multiple users are going to be using it. I want to create a front end and back end so that muiltple user can use. I have 2 question, 1. is how do I create a front end and back end split. 2. If my db have autonumber, does it matter if I create this db split. I don't want 2 people using the same auto number. thanks a bunch.

 

[RuralGuy]

Access has a built-in tool for that and has had for years. What version are you using?

 

[Sed]

2003,

I never heard of it, somebody recommended that to me but I don't know how to go about it. I have approx. 20 users/planners that's going to be using this db.

 

[RuralGuy]

Tools>[Database Utilities]>[Database Splitter]
It is pretty easy to do it manually as well.

 

[Sed]

When I did that, none of my form is listed on my _be (backend) Db.

 

[RuralGuy]

My favorite link for Multi-User: http://www.accessmvp.com/TWickerath/articles/multiuser.htm

 

[Sed]

Should I have a _be and _fe attached to the db?

 

[RuralGuy]

You go into the Linked Table manager and link all of the tables in the BackEnd. I'll be honest and I've only done it manually so I was not really sure how it worked. You are saying the tables are not linked after you run the Splitting wizard? *Only* the BE has tables, the FE has everything else.

 

[Sed]

Yes, my goal is to have exact same db with one db having _fe and the other _be. all the form should have linked, but it's not. I will look at you link and see if it's done differently.

 

[Sed]

FYI, it only created the _be it didn't create the _fe.

 

[RuralGuy]

I believe the db you are in *is* the FE! Only has linked tables.