access a frontend to access

[ecalbert]

i have a database and I would like to separate the frontend from the backend.
Can anyone point me to some articles on how to do this?
I know it is possible but I don't know how.

Also Is there anyway to let a frontend of access access a backend on a web server?

 

[ZmrAbdulla]

Split an Access database
You can split a Microsoft Access database into two files: one that contains the tables and one that contains the queries, forms, reports, macros, modules, and shortcuts to data access pages. This way, users who need to access the data can customize their own forms, reports, pages, and other objects while maintaining a single source of data on the network.
[ol]
[li] On the Tools menu, point to Database Utilities, and then click Database Splitter. [/li]
[li] Follow the instructions in the Database Splitter Wizard dialog boxes. [/li]
[/ol]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[lupins46]

'Also Is there anyway to let a frontend of access access a backend on a web server?'

It depends what you mean by this.
If you are using the frontend to maintain the backend on the same network (that is, on your machine you can navigate to the folder containing the backend) then yes.

If you mean can you access the backend over the internet from a frontend on a remote machine anywhere then the answer is no.