Edit mdf file

I am a newbie and at a complete loss what to do, perhaps you can help me to get my POS system back up and running properly. 
I have an .mdf database on a POS system that does not have enough horsepower to install the SSMS ( I keep getting installation errors)
I was able to isolate, copy and examine the MDF file on another Windows computer. (see attachment)

If you look at the attachment you can see my problem is in the USER table where the PINCODE column that has a corrupted PIN entry with a space in it and I want to correct it so I can access the POS application software on the POS computer.

My POS application will not allow me to enter the preceding space so I am locked out of my system administrator functions.
I have downloaded and installed the SQL Express server and the SSMS management studio on another computer, along with this corrupted MDF file, but beyond that, I am lost.
Any suggestions or procedures on how to edit this table with your tools would be greatly appreciated. 

I think it is a question of figuring out what software was used to create the MDF file.

It can be an SQL server local or SQL server compact, so if you have the list of the software already installed on the POS computer you should be able to see it. 

If you want you can email us your MDF file and we will have a look at it for you in the office

Hello Mike,

I believe my POS application uses SQL server local.  The app is SAMBA POS 4 which is open-source software.
Here is a link to a copy of the MDF file that the application uses that contains the corrupt PinCode in the USER table.
Any help you can provide to edit the corrupt administrator PInCode will be greatly appreciated.  I think (hope) removing the space or creating a new 4-digit pin would suffice. I am willing to pay for your service.
I am hoping that if I replace the MDF file that resides on the POS computer with an edited version with a good PinCode for the administrator that it would work again?

Regards,
Ross

Thanks, Ross

I was able to attach your mdf file to my SQL server using the following command.

USE [master]
GO
CREATE DATABASE [SambaPOS4] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS2019\MSSQL\DATA\SambaPOS4.mdf' )
for ATTACH_REBUILD_LOG
GO

I think in your case there is no need to do it.

Assuming you know the database username and password:

Install our DBrowser on a POS system  
Create a new database connection and connect to your database select the users table and edit it
Please post screenshots if you are having problems

 

Hello Mike,
After re-reading the installation for the POS app, it is a Compact Local Database.
I am still lost as to what to do. This is the error I get when I try to connect and browse the data.
What am I doing wrong?

 

 

We can connect remotely and assist if you wish

PS MS SQL server compact uses sdf files and not mdf's, so most likely it using SQL Server Express