Access Distribution in Multi user environment

[Blethyn]

Hi guys,

Im new to this forum so any help you guys can give me will be really appreciated.

I have a project due where i have kind of bitten of more than i can chew in terms of the time scale im looking at.

What i need to do is make a time and attendance database with the following sort of spec:

Web hosted access database

Seperate MDE file (think thats right!) comprising of just a switchboard that can be put on a cd, opened and will connect the user to the database for editing records etc.


I have some VBA knowledge but have lost touch over the years and have always struggled with recordset commands and the like.

If this is just impossible then tell me!

If not, any help is really appreciated.

Thanks Guys

[MMcCarthy]

Web hosted access database

Although this is achievable it isn't really practical to design a web frontend in Access. The recommended solutions is to design the web interface in something like Javascript, ASP, PHP, etc. and connect it to the Access database with OLEDB, ADODB or similar connection.

Seperate MDE file (think thats right!) comprising of just a switchboard that can be put on a cd, opened and will connect the user to the database for editing records etc.

The term mde refers to an executable (uneditable) version of the Access database. This would involve creating a frontend/backend database separation. You would need the backend for the previous part of the solution in any case. The backend would consist solely of your tables of data.

The front end would be your user interface (forms, reports, etc.) and would be connected to the backend by linking to the tables. The frontend is what is used to form the mde (always back up the mdb first as the mde cannot be edited, ever). However this can only be used on machines with a network connection to the backend data tables.

Mary

[Blethyn]

Hi

Thanks for your reply

If i was to host an access database on a server and then have a switchboard connect to this, would it make it more practical?

Basically, i need to be able to hand in a cd that can contains an interface and can connect remotely to a database but the way of doing it isnt defined.

Thanks again

[MMcCarthy]

You can have a backend/frontend database which is standard in a multi user environment. The backend sits on a common server and the frontend can either sit on the server or can be copied to individual hard drives. However, more than the switchboard sits on the front end. In fact the only thing in the backend is the tables which are then linked to the frontend.

Mary