How to read/write Access 2003 mdb records on server via INTERNET connection

25 pts.
Tags:
Access
SBS 2003
It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When opening via https, client Access downloads mdb to temp file where it can be manipulated. Problem - Changes made to temp file are not saved to mdb on server. Your advice will be greatly appreciated!
ASKED: February 4, 2008  10:53 PM
UPDATED: February 6, 2008  7:09 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

That’s because Microsoft Access isn’t a client server database.

You’ve got a couple of options.

1. Setup a second access database which has linked tables pointing to the current access database. The user then downloads the second database and when they make changes those changes would then be uploaded to the main database in real time. I’m not sure how well this would work however.

2. The better option would be to transfer the database from Access to the SQL Server which comes as a part of SBS, then have the users connect to the SQL Server database (this could be done via Access and linked tables) or create a new web based front end to allow the user to do the data entry via a web page.

As I said above, #2 is the better option as SQL Server is a client server database, and it’s designed for many people to be using it at once to update data.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RalphW
    Great! Thanks for your tip. I've elected #2 option, but . . . Hmmm, can't seem to find Enterprise Manager on my machine. From the Help and Support Center - To set up a user account on a SQL server - 'Open Enterprise Manager, click Start, point to Programs, click Microsoft SQL Server, and then click Enterprise Manager. ' Not there . . . Any ideas on how and where to find this? Thanks again! Nubee loves the KISS principle.
    25 pointsBadges:
    report
  • RalphW
    Okay, I've managed to find the Exchange Server Manager ( Exchange System Manager ) via Start - All Programs - Microsoft Exchange - System Manager I drilled down to Public Folders under the default COMPUTER NAME (Exchange) - Adminsitrative Groups - Folders - Public Folders A right-click on the Public Folder icon brought up a dialog box where I clicked on 'NEW' then clicked on 'Public Folder' In the 'Properties' pane in the General Tab I gave the new folder a Name and description and left the option for Maintain per-user read and unread information for this folder checked. All other tabs in the 'Properties' pane were left with default settings. I'm assuming that this is where I'd like to transfer the mdb ? How best to accomplish this transfer ? Nubee is learning slowly.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following