How do I share an Access query?

Question

If you can put a copy of the database in a location where the co-worker can access it, he/she can import the query through ExternalData. Easier, though, might be to open the query in SQL view, copy the entire text of the query, paste it into Notepad and give it to him/her. 1 мар. 2012 г.

How do I make a copy of an Access query?

Copy a query in a database1Right-click the query in the Navigation Pane, and click Copy.2Paste it into the Navigation Pane.Copy a query in a database - Microsoft Support

How do I allow multiple users to edit Access at the same time?

Make sure that Access is set to open in shared mode on all of the users' computers.1Start Access and under File, click Options.2In the Access Options box, click Client Settings.3In the Advanced section, under Default open mode, select Shared, click OK, and then exit Access.Ways to share an Access desktop database - Microsoft Support

How do I email an Access database?

Procedure1Do one of the following: Select the object in the navigation pane. ... 2Select External Data > Email. ... 3Under Select output format, select one of the available formats.4Under Output, select All or Selection: ... 5Select OK. ... 6In the message, do the following: ... 7When you are done, select Send.Attach an Access object to an email message - Microsoft Support

Expert · Answer