Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared workbook using a Data Entry form
All...
Can a workbook be set up to share among users if a data entry form is being used to capture input? -- Joe Mac |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared workbook using a Data Entry form
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. "Joe Mac" wrote: All... Can a workbook be set up to share among users if a data entry form is being used to capture input? -- Joe Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data entry form | Excel Discussion (Misc queries) | |||
put date and time in cells after entry made in shared workbook | Excel Worksheet Functions | |||
New record button grayed out on auto form w/ shared workbook | Excel Discussion (Misc queries) | |||
Data Entry in shared workbook | Excel Discussion (Misc queries) | |||
Data Entry in a Shared Workbook | Excel Worksheet Functions |