Access Web Database
94 TopicsSteps To Decompile Your MS Access-Database
"Steps To Decompile Your MS Access-Database 1)On a Windows system go to Start and type ‘msaccess.exe /decompile ‘in the Run command line. Here msaccess.exe includes the complete path of the Access Database. 2)Now go to Access and open the database you want to decompile. 3)Open any module as per your requirement and compile it through Debug, Compile.., and then File, Save...." My question: It´s about ACCESS 2013. Everyone is mention the Debug in Tool menu. There is no Debug option under Tools in our MS Access 2013 Database: Please see screenshot (Swedish version) Here´s the english translate the sceenshot. -References -Macro -Properties for DB -Digtial sinature As you can see, no DEBUG in the below screenshot. Really appreciate your answerSolved25KViews0likes4CommentsMigrating Access back end to the cloud
Hi. I am an amateur. Using Access 365, I have created a small Access database for a local charity and I would like it be usable by 3 or 4 people at once and so I think I need to get the back end (the tables) into the cloud. I have tried to set it up with Azure SQL, SQL Server and I've tried to use SQL Express as a stepping stone. But, in every case, the technology is impenetrable. I have downloaded endless software packages that I think the guys in India have recommended (although the language barrier is very difficult) so that I have installed MS Data migration assistant, MS SQL Server Express, MS SQL Server Migration Assistant for Access, MS SQL Server Tools 2018 and SQL Server Configuration Manager. Can anyone direct me to a step-by-step procedure, suitable for dummies, that can help me achieve this? Regards GrahamSolved17KViews0likes39CommentsI want to use access but I have a Mac
Hello, I was wondering if there is Access for Mac or if there is an online app where I can use it. Also, is it possible to save data in the cloud and have access to it from another computer. For example, I want to view the data that I entered at work on my PC in my laptop at home. Does this make sense?Solved15KViews0likes1CommentSharing and updating an ACCESS database on the cloud
I have implemented an ACCESS database. I would like to store it on the cloud so my colleagues can access it simultaneously. Some of them may be updating some data while others will look for certain records and files being stored within the database. I realize that I should do all my design and coding on my local PC then upload the file on the cloud; however, this central cloud copy of the database file should be accessed and updated while it is on the cloud by multiple users. I am not sure if storing on OneDrive would allow me to do this. I would highly appreciate any experienced developer in this issue.10KViews0likes12CommentsNumber of simultaneous users allowed to access database
Hi All, So far I have designed access applications for less tha 20 users. Now I have a requirement to develop something wherein users are around 130. I am thinking to develop front end using excel and back end using access database. However I am concerned whether such huge number of users are allowed or not. In total these 130 users will make around 21000 read write operations in a day . Need expert advise over it. Thanks in advance9.4KViews0likes4CommentsMicrosoft Access Giving error, File is already in use ,if access by more than people on shared netwo
Hi My name is Varun , happy new to everyone, I came across a issue with the Microsoft access Giving Error Cannot access the a file which is on shared drive, it can only work for one person at a time. if someone else try to use it says file is already in use.6.7KViews0likes7CommentsAccess on cloud
Good morning, I have designed a MS Access database and the frond end already contains all of the necessary UI. It is a multi-user database but not everyone have access to it. Meaning some of the colleagues have Macs. Could you maybe suggest a cloud based platform like a virtual machine environment or something where everyone can log into the browser and have access to the same MS Access file without needing to have MS Access on their personal comouters?5.9KViews0likes5CommentsMS Access & Sharepoint limitations
Hey everyone, I've got a topic I'd like to discuss that relates to my MS Access database. The situation is that I need to make it accessible remotely for multiple people scattered across Europe. Now, I know there are two options I can explore: Splitting the current database into two files, the Front End (FE) and Back End (BE). I'd store the BE file in the cloud and keep the FE file on my local machine. Rewriting the whole thing in SQL and storing it in MS SQL or something similar. My main focus right now is on the first option. But here's where I need your help: If I want to store the BE file in SharePoint, do you know if it can be done with SharePoint Online or if I need SharePoint Server? And how do I go about setting it up so that the local files stay connected to the backend at all times? My ideal scenario is to have multiple people with their own FE files, and any changes they make should update the BE in real time. I've spent ages searching for answers and even talked to support, but I just end up confusing myself more each time. I'm really looking for straightforward information rather than opinions. If any of you have any insights or can lend a hand, I'd greatly appreciate it. Thanks!5.7KViews0likes1CommentUnlock locked fields in MS Access
Hi Experts, I'm new to MS access. I've a file which I need to use as an input for my development work. I would like to know how I can edit the form in the file to update the required values. Please find the details below. When I open the file, the Main form shows the data as in the below screenshot. The shortage Data and Group Branch fields seems to be locked for editing. I would like to know how I can change this hardcoded value. My requirement is to change it to a different file path in both fields. As I mentioned, I'm a beginner in MS access. Please let me know if you need further information to resolve this matter.4KViews0likes7CommentsMissing data when joining tables in a query?
I'm brand new to Access, so not sure if I'm even asking the right question. I have one Table, tblStudents, that has many rows of students with columns such as student ID, student name, student mentor, etc. Another table, tblMentors, is joined to tblStudents that table via the Mentor ID column. When I drag tblStudents into the query design window and make a quick query with just their names and IDs, it returns 1930 students. However, as soon as I drag tblMentors into the design window, without changing anything else about the query, only 1116 students show up. This is remains true when I "reverse the join" by draging tblMentors into the design window before tblStudents. I assume this is happening because many students do not have a mentor, and thus the cell in their mentor ID column is blank--I think all of these students are just being excluded from the query. But I want to include all the students. Is there any way for me to fix this by adding something like "includeNullValues = TRUE" to the SQL? Or is it possible to fix it by applying Nz() to all of the tables referenced by the query? How? SQL that returns 1930 students: SELECT tblStudents.StudentID, tblStudents.LastName, tblStudents.FirstName, tblStudents.Class FROM tblStudents; SQL that returns 1116 students: SELECT tblStudents.StudentID, tblStudents.LastName, tblStudents.FirstName, tblStudents.Class FROM tblMentors INNER JOIN tblStudents ON tblMentors.MentorID = tblStudents.MentorID; SQL that returns 1116 students (with reversed join): SELECT tblStudents.StudentID, tblStudents.LastName, tblStudents.FirstName, tblStudents.Class FROM tblMentors INNER JOIN tblStudents ON tblMentors.MentorID = tblStudents.MentorID;Solved3.9KViews0likes6Comments