Updating an Access table without using Access

Slappy00

Golden Member
Jun 17, 2002
1,820
4
81
So I am trying to setup a simple task table using Access 2007 for my work that I can have a list of stuff to do and my maintenance guy can update and close out records.

I got the tables setup and the form. Since he doesn't have Access I tried the email method but it keeps sending him all the records, not just the ones that are still open (incomplete) and that is a recipe for trouble.

I have the ability to mess with Sharepoint but I am unsure of how to use sharepoint to make a remote form that he can fill out and use to update a database without having to use Access.

Is there a way to update a 2007 Database table without using Access other than email?

Thanks <3
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Develop a simple front end that can retrieve a record; allow the user to enter updates and write the record out.

Access could be placed on a common server and available for both you the other people that need to view/modify the data; just not at the same time on the same table. Disclaimer: I used this method back in the '97 time frame with great results.
 
Last edited:

Slappy00

Golden Member
Jun 17, 2002
1,820
4
81
Develop a simple front end that can retrieve a record; allow the user to enter updates and write the record out.

Access could be placed on a common server and both you the application; just not at the same time on the same table. Disclaimer: I used this method back in the '97 time frame with great results.

Thanks, I'll give it a shot!