how to split database and upload to server

[mazen911]

hi guys i am new in database design
i did a database by access 2010 which contain form and tables and i want to split it to backend and frontend and then make then in website

i need step in detalis to do that
how to split
how to put the backend on my site
how to make frontend in site
thanks

 

[Pat Hartman]

Access is a client/server application. It isn't going to work on your website. Each user needs his own copy of the FE loaded on his own computer. He also needs MS Access or the free MS Access runtime engine installed for the appropriate version of Access.

If you have control over the SQL Server on your website, you can use the upsizing wizard built into Access or you can download the SSMA (SQL Server Migragion Assistant) tool for Access from the MS Download site.

Some websites support remote linking to Jet/ACE databases but I would not recommend that for you because it will be EXTREMELY slow when fetching records. SQL Server will work better provided you have used queries with selection criteria as the RecordSources for your forms. With an Access FE linked to SQL Server over the internet or WAN, it is imperative that your application select as little data as possible for each form/report because all the data you select must be shipped over the wire and the internet, even with a fast connection is 100 times slower than the normal LAN.