Search results

Hello everyone, I want to address an issue I'm facing with ODBS connect failure error. I am using Access as a front-end application connected to SQL Server as the backend, and I have two machines, one at work and the other at home. Both machines have different names. When I load my application...

I have a dedicated machine with with windows server 2019 installed and sql server 2019. I also have multiple client PCs (Laptops) with access front-end installed and ODBC driver 18 n on them, every thing is connected using ethernet, a router and a ethernet switch. Everything works fine, except...

Hello, I have built an Access application that is a frontend to an SQL server backend. Now I want to distribute this application to end users, those users will, of course, have different server machines. I have some experience with installers like SSE Setup but it would be very much appreciated...

Hello, So I have this simple database that contains only two tables. one contains customers information the other contains their payments. I made a main form that pulls information from a query based on these two tables. When the user clicks on a record in this main form another form opens that...

Hello I have a form with a subform that is based on a table with required fields. When the user enters something then delete it with backspace in keyboard and want to exit the form, an error message appears that say "you must enter a value in "field name" field, the form is completely empty and...

Hello, I'm new to access and I have this little problem that is bothering me. I have a subform based on a table that has a field with the default value set to current date using the date function. Every time I open this subform an empty new record shows below whatever records is already there...