Networks

Ask something
Question Locked

Accessing Microsoft Access

0 helpful
6 replies

by dlcompu22

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way you can access Microsoft Access in multi-user mode thats on a Windows XP Workstation over the internet without installing Server 2003 and Citrix and have the ability to have 20 to 25 users log into it? I'am looking for the best way without spending a lot of money on user license's etc. Appreciate any help i can get.

6 replies

by himdownstairs

You could set it up on a host computer via a shared folder or a network drive, then have each user copy and paste the icon to their desktop (not shortcut). I've tried this on like 4 computers when updating a database for a trade show that my company ran and it worked fine. I would suggest, however, downloading a dummy database from office.microsoft.com and testing it out before you go live with your actual one.

by dlcompu22

Sounds like a great idea, but i need to access it from the internet.

by 1bn0

The first issue is the amount of users. Windows desktop operating systems. NT,2000,XP, and I would presume Vista, limit the number of concurrent (at the same time) connections to 10.

Thet second issue is multi user access to an access database. With 20-25 usrrs erformance could easily become an issue. Also has the database been designed with multiuser access in mind. There are extra requirements to allow multi user R/W access without corrupting your database or creating conflicts while users are editing the database.

"over the internet" just leads to a whole different set of questions.

If you couldbe a little more specific about what you are trying to do and why you have those requirements you might get a more helpful answer.

by himdownstairs

is an unmentioned variable. You might be able to get away with MySQL. But the question still looms as: "What are you trying to do?"

This discussion is closed to new replies.