Shared workbook using a Data Entry form

J

Joe Mac

All...

Can a workbook be set up to share among users if a data entry form is being
used to capture input?
 
J

Joel

I shared workbook can bed used in excel but it is not recommended. Excel
isn't designed to handle multiple access simultaneously. It would be better
to put the database in Access which is designed for simultaneous entry.

You can desing the form in either Excel or Access. Then write a maco to
store the form data into the Access Database. Excel macros can write data
into an Access database. Some people prefer to use Excel as a front end to
the database becaue more people are familar with use Excel than Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lock cells in a shared workbook 1
Locking cells in a shared workbook 2
Data aggregation with multiple workbooks 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Sharing workbooks limitations - Merged Cells 12
VBA in shared workbook 5
Data Validation on Data Entry Form 1
Macro to push data to another workbook 0

Top