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

Accessing MS Access Database

100+
P: 114
What is the method to access a MS Access Database located in a network server by client applications. Do we have to share the folder for the mdb file in the network as to make it accessible or do we have any other alternatives? If the sharing method is the standard method followed then i dont have any problem but if other alternatives is there, then i need to know. Please enlighten me!
Mar 7 '08 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
Hi raaman rai
Yes, you can have the access database (backend) on a shared network resource. This backend has all the tables that the clients need to have shared access to data.

Each user then gets their own access database (front end) stored locally on their computer. This database has linked tables to the tables in the backend and any queries, forms, reports etc that the users need to access and work with the data in the backend database.

Of course, an access frontend can be substituted with some other technology such as a visual studio appliction written in visual basic, C# etc. You can also connect to and use the data in the backend from web pages on your intranet. There are a mutitude of choices.

Does this cover your question?
Mar 7 '08 #2

Post your reply

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