I have a Database for MS Access. There is a menu which is provided in a form that allows the user to access the different functions.  This includes allowing you to add, change the records as well as the different reports.  Before, the users could see only the menu.  However, I changed the form for better access. Now, the users can now see not only the menu but also Access and the complete various Access.

How can an Excel spreadsheet be converted to an Access database? Also, how can an Access form be converted to a spreadsheet through the form as front for data capture? Can several users be linked to a database to allow data to flow into the database?

How do you hide system tables from programs like MS Access? Everytime I link tables in our SQL database, other system views are included in the list and I cannot find which tables I need asap.

Is there a way to export 400k rows in MS Access ’07 to Excel?

I want the row restriction of 65k to change to 1M in Access.

Is it possible to lock the records after the updates in Access database? I also would like the interface to show only a certain form for the user to fill out.

Hello!

Can you help me with my Access 2007? I would like for it to be accessed through the network in my office. How should I go about this one?

To all MS Access Experts, I need your help in creating a multiple charts using Access, which I will also use in PowerPoint. To those who are confused as to what I’m trying to do, I want to write a routine that makes and updates charts in PowerPoint by using the data from Access queries. Please help me regarding this issue. Thanks a lot.

Hi there! I want to know how to use char13 in Microsoft Access 97 but I don’t know how it was encode. At first, I thought it was written as “chr(13)” but it won’t work. So, does anyone here know how to write it correctly in Access 97? And also, kindly include a working code as an example. Any form of help would be deeply appreciated.

I recently installed Microsoft Access on my computer device. I want to download Northwind Sample Database so I do not have to create one for myself since it is readily available and I do not need an installer to be able to use it. But for some unknown reason the program is not working. I do not know if the problem is with the installation or the program itself. I hope somebody can help me.

Dears,