By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

Data Access Pages - Putting my db on the web!

P: n/a
Alrighty... one problem down... 40 more to go!! (Just kidding.. not
really 40.. only 32!)

My database needs to be accessible via the web. I have the server
information so when its ready I can upload.

I have my db filled with my data and I have a basic form created to
retrieve/view the data. What I need is for multiple users to be able to
access it at the same time via the web. I have played around a little
with saving my form as a data access page but each time I do, the combo
boxes I have set up on my form, are empty on the data access page. It
saves, no errors or warnings and creates the htm file. When I open it
and click on a drop box to select a record, nothing is in the list. I
did make sure they are using a query to pull the data in the combo
boxes and not the table directly.

Do I have to set up this database as a multi user db before I even mess
with the data access pages? Once the db is complete, all forms and user
access and everything ready to go... then worry about the web aspect of
it? OH and I need to keep all users, except the admin (me), from
making changes (adding, editing or deleting records) I think I can
figure out the multiuser stuff on my own. I just need help with the web
aspect I think.

Any help would be great!!

Thanks!

Jan 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Baz
Assuming this is an all-Access solution (i.e. it isn't an Access front-end
against a SQL Server back end) then without a complete re-write in a
different technology there is only one practical way to publish it to a
remote user over the web: terminal services over a VPN.

"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
Alrighty... one problem down... 40 more to go!! (Just kidding.. not
really 40.. only 32!)

My database needs to be accessible via the web. I have the server
information so when its ready I can upload.

I have my db filled with my data and I have a basic form created to
retrieve/view the data. What I need is for multiple users to be able to
access it at the same time via the web. I have played around a little
with saving my form as a data access page but each time I do, the combo
boxes I have set up on my form, are empty on the data access page. It
saves, no errors or warnings and creates the htm file. When I open it
and click on a drop box to select a record, nothing is in the list. I
did make sure they are using a query to pull the data in the combo
boxes and not the table directly.

Do I have to set up this database as a multi user db before I even mess
with the data access pages? Once the db is complete, all forms and user
access and everything ready to go... then worry about the web aspect of
it? OH and I need to keep all users, except the admin (me), from
making changes (adding, editing or deleting records) I think I can
figure out the multiuser stuff on my own. I just need help with the web
aspect I think.

Any help would be great!!

Thanks!

Jan 18 '07 #2

P: n/a
ok.. thanks!
Baz wrote:
Assuming this is an all-Access solution (i.e. it isn't an Access front-end
against a SQL Server back end) then without a complete re-write in a
different technology there is only one practical way to publish it to a
remote user over the web: terminal services over a VPN.

"Torilyn73" <to*******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
Alrighty... one problem down... 40 more to go!! (Just kidding.. not
really 40.. only 32!)

My database needs to be accessible via the web. I have the server
information so when its ready I can upload.

I have my db filled with my data and I have a basic form created to
retrieve/view the data. What I need is for multiple users to be able to
access it at the same time via the web. I have played around a little
with saving my form as a data access page but each time I do, the combo
boxes I have set up on my form, are empty on the data access page. It
saves, no errors or warnings and creates the htm file. When I open it
and click on a drop box to select a record, nothing is in the list. I
did make sure they are using a query to pull the data in the combo
boxes and not the table directly.

Do I have to set up this database as a multi user db before I even mess
with the data access pages? Once the db is complete, all forms and user
access and everything ready to go... then worry about the web aspect of
it? OH and I need to keep all users, except the admin (me), from
making changes (adding, editing or deleting records) I think I can
figure out the multiuser stuff on my own. I just need help with the web
aspect I think.

Any help would be great!!

Thanks!
Jan 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.