Anybody ever "split the database" so the relationships and queries are in one database and the "backend" could be the PC exported one?
http://office.microsoft.com/en-us/acces ... 42026.aspx
Search found 5 matches
- Tue May 08, 2012 7:06 pm
- Forum: Custom Reports
- Topic: Anyone regularly using Access .mdbs for reporting?
- Replies: 1
- Views: 1640
- Tue May 08, 2012 6:52 pm
- Forum: Custom Reports
- Topic: Anyone regularly using Access .mdbs for reporting?
- Replies: 1
- Views: 1640
Anyone regularly using Access .mdbs for reporting?
I wished to make a report on a table join not included included in the package. [See thread in Membership on "Offices Served"] I have made an Access export and built relationships and a query. When I re-export later with updated data the relationships and query previously built are gone. I have no w...
- Tue May 08, 2012 11:13 am
- Forum: Membership
- Topic: custom officer reports
- Replies: 10
- Views: 4995
Re: custom officer reports
In many cases here, former officers and committee leaders are no longer active members but are friends or ex-members still in the community. In addition I am interested in the proximity of their serving in (the stressful) president's position and their resignation dates. A report in committee/role o...
- Mon May 07, 2012 6:52 pm
- Forum: Membership
- Topic: custom officer reports
- Replies: 10
- Views: 4995
Re: custom officer reports
Ok, I waited till our office admin went home and exported the Membership and Skills stuff to an Access MDB. After the export I needed to input the relationships between ME, SKSERV, SKREF and SKCODES. Before I spent time polishing my query, I went back and imagined it was days later and time for upda...
- Mon May 07, 2012 11:23 am
- Forum: Membership
- Topic: custom officer reports
- Replies: 10
- Views: 4995
Re: custom officer reports
Re reports on Offices Served tabla SKSERV Its hard to understand how a need raised by BrianShoe in 2004 and 2005 is still unmet many revs later. You only really need to allow an entry point to run a query that joins tables....then we can export at will! :) Both formatted reports ONLY report on curre...