Client/Server Database

[CSCS]

Hi Guys,

I have a client database how can I put it on a server and manage it so certian client can use it ??

Thanks & Regards,
CS.

 

[jeremie_ingram]

What type of Server? What OS is it running?

You can always split a MDB into a FE-BE (front end - back end) system, having all of the GUI, queries, macros and modules in the FE and the tables in the BE. Put the BE on the server, and distribute the FE to the end users.

You options of security will depend on the server system unless you enable the security options within access. I would recommend putting the BE into hidden shared folder on the server that has restrictions set on who can access it. This would also ential that each user has Access installed locally, otherwise you would have to distribute it with the runtime environment.

 

[CSCS]

Hi jermie,

The OS is Windows XP

the question is how can I split the MDB into FE-BE ? and how can I connect between the FE and BE, I'm new at this, so I need a little more details.

Thanks & Regards,
CS.

 

[Kevin_S]

Search this forum for "How to split database" or "splite FE BE"... You will find all the info you need as this has been covered many times...

HTH,
Kev

 

[CSCS]

help needed to share a MDB on a network ASAP

this is what I did,

the databse I'm working on has tables, forms, queries & reports, and I've been enterring data in this DB for a while, i.e. it has alot of records.
I've been able to Split the DB, so what I have now is 2 Databases:

MyDatabase.mdb , which has: tables, forms, queries & report
MyDatabase-be.mdb , which has the tables only

now what is the next step in order to share this database on a network ?

any help will be very mich appreciated.

Thanks & Regards,
CS.

 

[Parker]

so what I have now is 2 Databases:
MyDatabase.mdb , which has: tables, forms, queries & report
MyDatabase-be.mdb , which has the tables only.

No! ---- What you have now is an FE (MyDatabase.mdb) and a BE (MyDatabase-be.mdb)

If you look closely at MyDatabase.mdb you will notice that it contains linked tables. If you try to open one of these tables in design view then you will get an error mesage telling you that you cant modify the design of a linked table.

If you open MyDatabase-be.mdb you will find that it contains only the origonal tables with no forms, queries, etc.

now what is the next step in order to share this database on a network ? any help will be very mich appreciated.Thanks & Regards,CS.

Now go and review your posts. If you still have problems understanding the process people will help you.

Search this forum for "How to split database" or "splite FE BE"... You will find all the info you need as this has been covered many times...

But if you don't try people will be reluctant.

On this subject it appears that you haven't tried.

This is a relatively easy and very basic process. jeremie_ingram has outlined what is necessary and you have been asked to search the forum. I would suggest that either you have not bothered to do this or you have done it but not read the results properly. If you had you would not be posting the question quoted. In the event of a problem you would have much more specific questions.