How to save Access Queries - TechRepublic
General discussion
December 4, 2002 at 03:01 AM
dave butler

How to save Access Queries

by dave butler . Updated 23 years, 6 months ago

We have a custom built database that consists of an Access 2002 frontend to a SQL Server 2000 database. In order to distribute changes to the program (not the data) to local desktops, our consultant has implemented a login script that overrights the users mdb file each time they login. The problem with this is that users lose any queries they have built.

How can we allow the users to keep their personal queries without loading the production with extaneous stuff?

I would appreciate any tips, including useful links to sites.

Thanks,
Dave

This discussion is locked

All Comments