Newbie!!! Need to know whether to upsize

[Smurfman]

Ok I have an access database and it's working great so far. It's in *.mdb format and i want to know whether i can network it. I don't know whether i should upsize to SQL server to network it. And if i can network it without upsizing it how do i do it?
Thanks
Chris

 

[Databaseguy]

Several options:

1. Put the whole thing on a shared directory on the network.
Slow, but easy to administer. (You do have to get evryone out to make schema changes, though)
2. Split it using the splitter. The tables go on one DB on the network, the Forms/Queries Etc go on another on each workstation. I've used this several times. A little faster then #1, but hard to administer duplicate copies on all workstations.
3.Upsize- You'll need SQL server, and all of your objects may not upsize. Fastest, most scaleable and most complex of the three options.
4. Intranet using ASP, IDC etc. No one needs the Access Database product, just a browser. Limited in functionality.