MS Access database

pts.
Tags:
Microsoft Access
Microsoft Access database
I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems that the connection string is a stumbling block. All suggestions welcome. Thanks in advance for your help.

Answer Wiki

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

If your end users have MS Access installed on their machines, then you could just have them link to the MDE file on the server via a windows shortcut. This method even supports having multiple users at a time.

Discuss This Question: 3  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
  • Mgregory
    The clients will be using MS Access 2K and it's not compatible with .mde files. All I want them to do is use online records. It seems I could do this by either having Access tap the records online or by using Data Access Page. If I could have them open Access and have the online records pop up, that would be perfect.
    0 pointsBadges:
    report
  • CharlesJC
    mgregory, Here are a few options: - Create a form in the database on the server and let the users access it directly. - Create a Access 2k database with the updatable tables linked (File -> Get External Data -> Linked Tables) to the database on the server. This will basically use Access 2k as the front end to the data. - You can combine the first two ideas, by creating an Access 2k database with linked data tables and create a form in the Access 2k database that the users can update. Hope this helps. Charles
    0 pointsBadges:
    report
  • Mgregory
    Creating the form for online access or placing links to db online are note working either. Think that part of the problem is that access is used as dsn for ms sql....currently installing visual web developer, ms msdn, and ms sql server express in order to write .asp pages to interact. Part of the problem is with this windoze webhost control panel....very limited.
    0 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