Search results

In Access can I link to a SQL Server view? I am currently linking to the SQL Server tables in my database and don't have any views. But if I can link to views I could give the workgroup permissions in Access to the views, not to the primary tables. This would provide some added security from...

I am trying to implement DLookup for the following sql to a linked SQL Server table to verify that the currentuser is in my Traders table: select tr_username from Traders where tr_username='edobbie' When I enter the following DLookup command I get the error 'compile error expected =' The...

Is there a way I can use the workgroup's group permissions to restrict access to selected switchboard's options? Ideally, I'd like to supress displaying selected options based on the CurrenUser's group permissions. Failing that, I'll settle for a 'you can't do that' message, if an option is...

I have the security set via the Access workgroups for both groups and users. I want to be able to use the username entered on the logon screen to filter my query results. How can I get the logon id that was entered when my switchboard form opens? Thanks in advance. Dennis Cronin

I have nearly 100 queries in an Access database which links to a SQL Server database. The queries are working just fine. I have created a new Access database, linking to a different SQL Server database which has the same table layouts as the first. Is there a way to automatically copy the...

I have 61 pipe delimited files in a Windows 2000 folder. I need to write a script (VB?) to create 61 Access tables, which I have done manually in the past. Each file is different with a different number of rows and columns. It is not necessary that the columns be named anything but the default...