ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple users for spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/145840-multiple-users-spreadsheet.html)

Dirk_Bob

Multiple users for spreadsheet
 
I have a spreadsheet linked to an access database. How can I setup the
spreadsheet so mutliple people can access the database at the same time?
--
Dirk

Earl Kiosterud

Multiple users for spreadsheet
 
Dirk,

I don't know if a sheet linked to an Access table can be shared (Tools - Share Workbook),
but I certainly wouldn't want to do it. Sharing workbooks is known to have problems.
Access handles multiuser stuff well. Let the users get access to Access with Access. If
they have Access.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Dirk_Bob" wrote in message
...
I have a spreadsheet linked to an access database. How can I setup the
spreadsheet so mutliple people can access the database at the same time?
--
Dirk





All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com