Hot answers tagged

6

Yes you can use MS Access as a front end to SQL Server. Its quite common. I have done this myself in the past. No, Access itself won't corrupt data. However your Access application needs to be designed so that it respects SQL Server constraints and rules. Also how will your Application stop users from making simple mistakes, like deleting records if they'...


5

If they have access to the tables directly with insert, update and/or delete rights then they can corrupt your data. If you prevent this by limiting the access-rights or by an MS-Access application then they can/should not be able to corrupt your data. About business rules. According to Wikipedia: A business rule is a rule that defines or constrains some ...


3

The undocumented Stored Procedure xp_dirtree requires the sysadmin fixed server role in order to see any files when the procedure is called. Adding this role to your user test should enable you to see the results. It is also worth repeating what has been mentioned in the comments; As this is an undocumented feature of SQL Server it could be removed in a ...


1

I think you need a LEFT JOIN or an inline subquery. The FROM b is also missing. For the NULL to be converted to 0, you need the equivalent of COALESCE() or ISNULL(), which is the Nz() function in Access: SELECT a.partNumber, Nz( (SELECT SUM(b.purchased) FROM b WHERE b.partID = a.partID ), 0) AS sum_purchased FROM ...


1

Is the front-end locked down (for design) and properly linked to the back-end? If they are, you will need to go back to your development copy, save it on the end-users' machines individually, and re-link to the databases on the file server. i have a VBA script that runs when the front-end starts up that checks for the existence of the backend. if the ...


1

Where My_ID = ID0001, ID0002, ID0003… IIF(Val(Right(DMax("[My_ID]","[MyTableName]"),4))+1<10,"ID000" & Val(Right(DMax("[My_ID]","[MyTableName]"),4))+1, IIF(Val(Right(DMax("[My_ID]","[MyTableName]"),4))+1<100,"ID00" & Val(Right(DMax("[My_ID]","[MyTableName]"),4))+1, IIF(Val(Right(DMax("[My_ID]","[MyTableName]"),4))+1<1000,"ID0" & Val(...



Only top voted, non community-wiki answers of a minimum length are eligible