dkuzminski
Technical User
Setting up a web-based Access database is something I haven't done before. Basically, I need some guidance on what I need in the way of resources or what actions I need to perform.
A department in our office wants to set up a database on the Internet so that some remote users (3 or 4) can enter data and produce reports. The database is small and will probably not have over a few hundred records at most in any of the tables, though it may grow somewhat in the years to come. It's also relational with six tables that relate to each other. Four of those are available as tabs on the master table's form. One is a sub-related form (table) to one of the tabs.
The master table tracks the groups. Each group can have multiple projects. The projects are in one of the tabbed forms.
One of the tabs is simple, but performs math as it tracks the budget for the group by month. Essentially, it's a table with 15 fields with one record per master table record. One is an index relating it to the master table, one field for the total budget, one to show the remaining budget, and one for each month's expenses. It simply substracts the months from the total to display in the remaining budget field.
The rest of the forms that are tabs on the main form are used only to enter completion dates and such.
Okay, that's not much of a description, but it should give some idea of the database that's set up and works already as a pure Access database on a local computer. I've already tried making web pages of some of the forms only to see the main form produced without any tabs leading me to suspect that the database will have to be restructured in order to work over the Internet.
Any suggestions on what I will need or should watch out for will be appreciated. Thanks! DaveK
A department in our office wants to set up a database on the Internet so that some remote users (3 or 4) can enter data and produce reports. The database is small and will probably not have over a few hundred records at most in any of the tables, though it may grow somewhat in the years to come. It's also relational with six tables that relate to each other. Four of those are available as tabs on the master table's form. One is a sub-related form (table) to one of the tabs.
The master table tracks the groups. Each group can have multiple projects. The projects are in one of the tabbed forms.
One of the tabs is simple, but performs math as it tracks the budget for the group by month. Essentially, it's a table with 15 fields with one record per master table record. One is an index relating it to the master table, one field for the total budget, one to show the remaining budget, and one for each month's expenses. It simply substracts the months from the total to display in the remaining budget field.
The rest of the forms that are tabs on the main form are used only to enter completion dates and such.
Okay, that's not much of a description, but it should give some idea of the database that's set up and works already as a pure Access database on a local computer. I've already tried making web pages of some of the forms only to see the main form produced without any tabs leading me to suspect that the database will have to be restructured in order to work over the Internet.
Any suggestions on what I will need or should watch out for will be appreciated. Thanks! DaveK