Tag Info

New answers tagged

1

I guess one of the easiest ways to do this would be installing a SSH client on Windows and then using a SSH connection to trigger the script on the Linux side. The command to call on the Windows side could be as easy as something like this: ssh.exe user@hostname /path/to/the/script Note that your ssh client will need some way to directly authenticate ...


1

Are you running SQL queries? If so, you can use the replace function to replace one character in a name with another. UPDATE table SET columna=replace(columna, '?', '"'), columnb=replace(columnb, '?', '"'), ...and so on


1

One year, as a science teacher of a small private school, I had to do report cards for 300+ students because the grading computer system in place was no longer accessible (a mini-crisis of sorts). With no budget for more actual grading software, I was left to use Excel and/or Access to make report cards. I decided to use both Excel and Access. Here is ...


1

I have been in similiar situation in the past. For the simple management of one course, I was able to do everything with Excel and also use this data easily to generate word documents. Some years before I programmed a student management tool in Access. For this purpose (many courses, different tasks, different degree paths etc.) and the fact that the ...


2

Storing students' information and performance would be easy in either Excel or Access. In Access, OP would just need one table. However, calculations are much harder in Access, because the function interface is highly nonintuitive. Also, using calculation in Access is overall far less intuitive, because functions operate on arrays, rather than on individual ...


0

I think this is primarily opinion-based, but here we go anyway. If you are not a computer professional, you should never use MS Access. I think it was very unfortunate that MS produced Access, providing the illusion that non-computer professionals can mess around with relational databases. If you try to do it, you will get it seriously wrong. If you are a ...


5

I would go for MS Access because if a user has to fill in the sheet, it becomes prone to errors. MS Access is a database and can calculate fields and protect fields based on earlier entries. It is more advanced to build the sheet, but if done properly, it will be far easier to fill in. Additionally, it is easier to generate a proper report showing just the ...


0

Have you tried holding down the shift key while opening the database? This basically allows the database to bypass any startup options that might be blocking you from editing the database. Bypass startup options when you open a database


0

It is not possible to hide/unhidden form controls without the use of macros/vba within ms access.


-1

I would recommend Navicat (Not free but has 30 days free trail). It is a good tool as far as visual query building is concerned. :-)



Top 50 recent answers are included