Recent content by uyuni

I apologize in advance as I am not familiar with either RDS or Citrix. I have a multiuser Access DB, small size being used by a few people. The client will be moving to Sharepoint, so the DB will not work due to Sharepoint limitations. I have prototyped it on Azure DB back end, using a free...

I am leaning towards Azure SQL, but am a little worried about what it is I don't know, i.e. surprises that I may encounter. The application itself is quite small in size, the tables do not have any referential integrity (it is in the app). There is very complicated calculation logic written in...

A while ago I wrote an a multiuser Access application split into the Back End (data only) and Front Ends (everything else). The volume of data is relatively small and the number of users is 3-4 max. The client is migrating to Sharepoint and I have read a number of posts that caution that it is...

Thank you George. There are a bunch of forms and I was trying to save time, as all of them except one fit just fine. Wrt the default printer, does it matter if I use acFormatPDF in my output statement?

I am trying to output a form into pdf using DoCmd.OutputTo One of the forms is quite large and does not fit on one page. I tried to specify the 11x17 size paper and it seems to work on my computer, but not a different machine. 1. Is it possible to specify something akin "shrink to fit" so...

The back end has to be in Access unfortunately. If I use a password for the back end, then this password has to be included in the front end VBA code, and hence it is hardwired, is it not? i.e. the administrator cannot change it? Thanks again for your help. -u

Thank you for your reply. But let's say I have privileges where UserA can do everything, but UserB cannot modify or delete. UserB can still then open the back end and delete something, correct?

I am planning to build a multiuser access DB. I plan to split the front end and the back end. I understand the idea of creating a table with user IDs (network logons) and their corresponding passwords and privileges. The front end then checks the password against that table and determines the...