Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

need to upload ms access database to windows server and ...
Sent to Computer Experts September 19 03:15 PM

need to upload ms access database to windows server and have user enter/edit live data from ms access on their computer.

the ms access db is listed as dsn in ms sql db on server as per their requirement.

need to know how to access the info in a form or dap

 

Optional Information:
OS: Windows XP; Browser: IE

Customer (name blocked for privacy)
Status:  Closed   Value: $8
Info Request
September 20 9:43 AM (18 hours and 28 minutes and 3 seconds later)
         
REPLIED to Info RequestCheck Mark
Hello mgregory,

A little more history on your project please.
Have you split the ms access database into front and backends?
Do you plan to service a small number of desktops with the database or many machines?
Is this an Access project you are trying convert to SQL?
CompuHelp -- Consultant -- Expert's Profile
26 years in computer related fields
Reply
September 20 11:33 AM (1 hour and 49 minutes and 20 seconds later)
         
Reply to CompuHelp's Post: Thanks for your reply.

In response:

Have not split into DE & FE since will be used by clients with MS Access 2K and they would not be compatible.

Probably dozen or less clients

Access project that I want left as Access and connect remotely.
Customer (name blocked for privacy)
Answer
September 20 12:25 PM (52 minutes and 26 seconds later)
         
REPLIEDCheck Mark
mgregory,

You should investigate connecting to the assigned DSN through OBDC on your desktops. You can link to the server based tables. Sometimes a little slow but in your case probably not noticeable to the end users. OBDC is accessable via various paths on different operating systems. If memory serves me correctly, via admin tools on both 2000 and xp.
CompuHelp -- Consultant -- Expert's Profile
26 years in computer related fields
Reply
September 20 1:14 PM (48 minutes and 20 seconds later)
         
Reply to CompuHelp's Post: problem with server access is when you use dsn for ms sql db, then you have to recreate the web interface with .asp pages.

Also, have discovered that most servers in datacenters will no longer support data access pages.

Now I'm relegated to doing the following:

Set them up on dedicated box. Use remote admin prog to manipulate/update MS Access database, forms, etc.

Allow end users to get to the database via Windows Terminal Server.

I will have to create links for dtabase on server and build an interface for them to select another database that is now planned.
Customer (name blocked for privacy)
Answer
September 20 3:36 PM (2 hours and 22 minutes and 12 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
CompuHelp -- Consultant -- Expert's Profile
26 years in computer related fields
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the Just Answer service comes from those individuals, not from Just Answer!, and that Just Answer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on Just Answer! are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. Just Answer! is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

Just Answer! > Computer and Software Help