Hi
-
HI. I have a small software build in Access.I need to build a new version of this software with C# interface and the DB in Access again.How to create an installer that I can use the file of DB separately??? I mean the guys who will use this software cannot have a continuously access to internet so till now they enter the data in the existing Access 2003 software and then they send this data by email to the center where the main operator merge this files to one.I need to implement the new C# software because of reporting possibilities and nice interface.But the DB data has to be the same and used the same way as before.Please every idea of best practices or solutions will be appreciated.
-
HI. I have a small software build in Access.I need to build a new version of this software with C# interface and the DB in Access again.How to create an installer that I can use the file of DB separately??? I mean the guys who will use this software cannot have a continuously access to internet so till now they enter the data in the existing Access 2003 software and then they send this data by email to the center where the main operator merge this files to one.I need to implement the new C# software because of reporting possibilities and nice interface.But the DB data has to be the same and used the same way as before.Please every idea of best practices or solutions will be appreciated.
It's a simple matter of creating a connection to the access database and building your user interface. Take a look at connectionstrings.com for the syntax for the connection string. This is not a design I would recommend as it requires too much manual intervention, however this may meet your requirements and skill level. Consider getting a professional to build this app based on sql server, CE and replication.
Never underestimate the power of human stupidity RAH
-
It's a simple matter of creating a connection to the access database and building your user interface. Take a look at connectionstrings.com for the syntax for the connection string. This is not a design I would recommend as it requires too much manual intervention, however this may meet your requirements and skill level. Consider getting a professional to build this app based on sql server, CE and replication.
Never underestimate the power of human stupidity RAH
I agree with you that SQL is much better regarding DB. But my users are not IT professional and I don't have any idea how to make simple for them file sending from different cities and merging all the data at the center.With Access DB they just send their Access file not bigger than 2 Mb by email and the center operator has an Access file merger software. If you got any clues on this issue please consult me and I will use SQL with joy