connecting ms access to a server

I am currently working on an application for a business which is nearly completed. I am using MS Acccess on my computer and was just wondering how I upload the database on to their server. Also how would I go about copying the data. I have never done this before so I am having real problems with it

re: connecting ms access to a server

First you'll want to split the database into a "Front End / Back End". This is important to avoid the database becoming corrupted, especially if you are intending this to be a multi-user program.

Then you save the back-end into a location on the server where it won't accidentally be moved or deleted by some other user.

Then copy the front-end onto each user's computer. The front end will contain all of the forms, reports, queries, macros, etc. (which can be slow if the user were trying to run the front-end from the server). The back-end, located on the server, will only contain the tables. Everyone's copy of the front-end will be individual files on their own computers, but all of the data will be stored in the single back-end file on the server.

The help menu and googling will give you good instructions on how to split your database into front-end and back-end.

By the way, the users will all need Access on their computers as well.

re: connecting ms access to a server

If this question is meant as stated, then copying the database onto the server is as simple as copying the database file (xxx.mdb).

If not, simply explain exactly what you need to know and we'll see what we can do to help.

Welcome to Bytes!

re: connecting ms access to a server

You can also find some info here at Front-End / Back-End (FE/BE).