By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

connecting ms access to a server

P: 1
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
Jan 8 '09 #1
Share this Question
Share on Google+
3 Replies


tdw
100+
P: 206
tdw
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.
Jan 8 '09 #2

NeoPa
Expert Mod 15k+
P: 31,186
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!
Jan 8 '09 #3

NeoPa
Expert Mod 15k+
P: 31,186
@tdw
You can also find some info here at Front-End / Back-End (FE/BE).
Jan 8 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.