•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 329,242 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,269 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:
Views: 227 | Replies: 1
 |
•
•
Join Date: Apr 2008
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Sorry for the lengthy question, but here goes:
I currently have an access database with a FE and BE that resides on each users laptop. Weekly they connect to the network and synch the BE the master on a network drive. There are numerous propblems with this as it has grown quite extensive.
We would like to have this be a server based database with the remote users either having access through the web or something else?
A few of the capabilities of the current database:
1. generate and print reports 2. update project forms. 3. enter time logs 4. enter notes
My question is:
What are my options for a remote FE? I am well versed in VB6 and Access. Would be willing to learn other languages (VB.net, my SQL, etc.) Would I be able to have the same functionality or would I have to have separate software for certain functions?
I currently have an access database with a FE and BE that resides on each users laptop. Weekly they connect to the network and synch the BE the master on a network drive. There are numerous propblems with this as it has grown quite extensive.
We would like to have this be a server based database with the remote users either having access through the web or something else?
A few of the capabilities of the current database:
1. generate and print reports 2. update project forms. 3. enter time logs 4. enter notes
My question is:
What are my options for a remote FE? I am well versed in VB6 and Access. Would be willing to learn other languages (VB.net, my SQL, etc.) Would I be able to have the same functionality or would I have to have separate software for certain functions?
•
•
Join Date: Sep 2007
Location: North Bay Ontario
Posts: 171
Reputation:
Rep Power: 1
Solved Threads: 20
Junior Poster
I'm not sure what you mean by 'FE' or 'BE', but if you are planning on mounting this database on a web server I suggest you forget about using Access. Actually Access is not even the database, but Microsoft's front-end to their JET database.
It is not designed for multi-user use.
Look at MySQL or some other RDBMS. Anything you can do with your current set up can be done in MySQL. It's a matter of migrating your data over, and writing the program front-end.
It is not designed for multi-user use.
Look at MySQL or some other RDBMS. Anything you can do with your current set up can be done in MySQL. It's a matter of migrating your data over, and writing the program front-end.
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
DaniWeb Marketplace (Sponsored Links)
Linear Mode
- Newbie Question - How to generate a link (PHP)
- Redirecting - Newbie Question (PHP)
- Basic scripting question (Getting Started and Choosing a Distro)
- HttpContext.Current Question (VB.NET)
- newbie... Java load large picture :) Lit'l help plez (Java)
- Newbie Question - Hiding php extension (PHP)
- Stupid Newbie Question (C)
- AGP Aperture Size Question (Windows NT / 2000 / XP / 2003)
- How to network two Win98 machines (Networking Hardware Configuration)
Other Threads in the Database Design Forum
- Previous Thread: ERD Diagram with inheritance
- Next Thread: Quantity Per Unit value is not unique.
