Besides having a limit of 2gig database size, which includes the space taken up by tables (& its indexes), forms, reports, queries, and macros, opening back-end tables from within the Run-time environment is slow, and has limits on the number of concurrent users. Also trying to open up access databases from the internet can be a challenge. I've never had to, but I've read that its not easy.
MS Access is ideal for small businesses though, as setting up tables, and forms, and reports are fairly straightforward.
