Search results

Hi all, I upgraded my database form mdb to apd and found out that the charts I created using the chart wizard in my mdb file were lost. I found out that I can create new charts in adp by inserting a chart object but this option does not give me the flexibility of grouping and formatting the...

Thanks Pat Hartman!!! You are right. It was the first problem and as soon as I make unique keys, it worked. I guess the data import/export wizard does not import unique keys as unique keys, or I didn't know how to instruct it properly. Thanks, Nanfa

Hi All, I upgraded my Access db from mdb to apd with all data exported into a sql server database and then I exported the forms reports and modules from the mdb to the apd. Everthing seems to be okay except that I cannot edit any data from my tables or forms from within access. This is the...

Hi. Thanks for the reply but I'm using an Access project with SQL Server security. Adding another layer of security will require users to log into the database twice???

Hi All, Please is there a clever neat way to hide my tables or disallow users from accessing them directly. I have created forms with validations, and restrictions to achieve data consistency and protection. Now, if any user goes directly to my tables, they can easily mess things up. Has...

Hi All, Please, I am creating an Access Project connected to a SQL Server database. How can I hide or deny access to certain tables, forms, reports and query objects? I need all data access to be through specific Forms and Reports. All other objects should be inaccessible. Thanks, Nanfa

Thanks Hayley Baxter! It works for getting the logged in user when the Access project is connected to the SQL Server databas using Windows authentication. The next issue is getting the logged in user when the Access project is connecting to a SQL Server using SQL Server Authentication. Please...

Hi All, Please I am designing a multiuser database and I need a means of automatically getting the name of the logged in user. I know I can use the currentuser method if I was using a workgroup security file but I'm using an Access Project connected to a SQL server database using windows...

Hi all, Please I have a created an Access 2002 database with tables and forms. I placed it in a shared folder and I want several sales execs to add data to it simultenously. The problem I am having is that I can open the database and make edits but all other network users get a read-only...