yoducati
asked on
Create Web Form Access 2010
I have an existing Access 2010 database with a lot of VBA code. I'd like to be able to add a couple very simple webforms so that users can submit data to the database but I am not sure how to accomplish this. I know a hybrid access database can be built but I guess I'm concerned that I would have to start with a "web database" and I dont want to recreate this whole thing. Is there a way for me to add a simple web form for use through my company intranet without recreating the whole database?
PatHartman
Access web apps are being deprecated and in fact SharePoint will actually stop supporting them in 2018 so I wouldn't build any new apps. If you have SharePoint, you can still link to SharePoint lists and use that as a way of transmitting data. Remote users can use an Access app you build for just this purpose and the main app can link to SharePoint and collect the data. If you want/need a real web page because your users are anonymous, you'll have to build it with something else such as ASP
ASKER
This isnt for a new app, this is more of a temporary solution until we are able to build a robust enterprise solution. In the meantime, we do have sharepoint but I have mostly been frustrated by trying to do a simple form for users to submit data, even with the back end being linked to sharepoint lists. Although I can create a linked table and update data in either access or sharepoint and see the results either way, when I get to the forms piece of it I keep hitting roadblocks. I was hoping the access web form would be a relatively quick solution, but I admitedly only have intermediate expertise with regard to sharepoint. I am not impressed with infopath, and do not have administrative rights so I can't install software and dont have access to anything like visual studio so I was trying to come up with a workaround. So you are saying build the access app for the form to submit the data to the list, and then have the database link to the lists?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We have an existing infopath form that links to a sharepoint list. I have already linked my database to that list, but the database was already a split fe/be. There is an existing workflow I need to retain, but it is tied to one big list of data which in my database had already been normalized across multiple tables. I guess I would need to make sharepoint my back end for the entire DB and adjust the lists accordingly?
No. There is no problem linking a FE to multiple BE's. I do it all the time. Sometimes they are multiple SQL Server or Oracle or DB2 or even a mix and sometimes they are various .mdb's or .accdb's or .dbf' (Foxpro)
The only issue you face is the failings of the linked tables manager so I built my own forms for swapping Access to Access, SQL Server to SQL Server or even in one case Access to SQL Server and vice versa.
If you don't build your own relinker, the best solution is to use different prefixed for different databases so all tables of one BE sort together in the linked tables manager.
The only issue you face is the failings of the linked tables manager so I built my own forms for swapping Access to Access, SQL Server to SQL Server or even in one case Access to SQL Server and vice versa.
If you don't build your own relinker, the best solution is to use different prefixed for different databases so all tables of one BE sort together in the linked tables manager.
ASKER
Ok. Ill keep messing with it. I was initially having issues with data types etc. between lists and what I have in the database already so maybe after I clean everything up I'll have better success. Thanks!