Search results

Thanks for your replies. I live in Greece and there is no way to do this here. Second, I am not so young, and I am already in business, but I want to expatriate, and find a job in Central or N. Europe (I would also relocate to overseas, but it is not an easy thing to be accepted). I think a...

Hello there, I couldn't find a more suitable section to place my question, which is as following: is it possible for a person to study Computer Science in a distant course? I work for several years in computers, I make applications, administer servers and databases, but I lack the "paper" and...

I have the following 2 queries: SELECT DISTINCTROW tbl_members.surname, Count(tbl_years.year) AS CountOfyear FROM tbl_members INNER JOIN (tbl_years INNER JOIN tbl_subscriptions ON (tbl_years.ID_year = tbl_subscriptions.ID_year) AND (tbl_years.ID_year = tbl_subscriptions.ID_year)) ON...

You wrote Considering that Access alone costs $200 and developers edition $500, I see that it is a bargain if you need more than even 2 licences and not 4. In that case it is really reasonable and I will search for it. Thanks a lot.

I found a separate distribution of Access for 250 Euros. Considering what you write above, it shouldn't be possible.

It is a hardware problem. The file from the CD cannot be read. I have several CDs where that happens, unfortunately. What you should do is NOT to trust CDs. If it is precious work on them make more copies. Try known companies, I use Imation or Tayo Yuden. For this case, try to read the CD from...

What would you suggest instead?

Well, thanks. Rather an expensive solution if you have many pcs. It's better to write an App which should query the mdb file and let one user insert and delete data, by using Access's interface.

I agree about MySql, it's "heavy artillery" and free. Btw, did you check 'Compact on Close' at Options-Menu in Access? It might help.

Still, you can go to Design View by right-clicking on a form, table etc. Also, I think there isn't a way of undoing this action in the future, is there?

Hi, I have a 5 PCs LAN and there is an Access application built in one of them. Do I need 5 Licences of Access in oder to read data from that particular application/database? Does this mean that we have to buy 5 times the same product or is there another cheaper way? Thanks for any reply.

Is there any Access viewer from Microsoft, like the others for Word, Excel and PP? It would be nice if clients can browse forms and print reports without having to buy Ms Office. But I could not find anyone.

The sample made by ghudson is there http://www.access-programmers.co.uk/forums/showthread.php?t=97787 It has been very useful to me, since I am able to get a table with the files of my CDs by using the 'fScanDirSelectFileFromTable' Form. Following his request I post my question here: What...

Thanks, I got what you mean. Still, I would like to know if there is a way to have an Access DB created from a plain text file (which, I guess, should be an Sql file), instead of creating the db first in a MySql or Ms Sql server and then transferring it into Access via ODBC or another 3rd party...

But Access is SQL capable, isn't it. You can always write directly in a query SELECT * FROM tablename and you will get all the rows of the table. Is it impossible to handle CREATE?

Hi, a ER programm gives the following output to an sql code, which it pretends it should be for Access 97. Till now I haven't found an idea of how to create a table using the SQL statement CREATE. As a matter of fact it returns me an error of Create statement or something, even if I tried any...

Is there a solution, without having to redesign the whole database and introduce a new tblParents table? The advice that Pat gives in the other thread assumes that there is a tblParents which cannot exist under the current circumstances.

This seems to be correct. The problem is that at the beginning it wasn't ment to need the parents' names and their professions to do some specific job other than just retrieving the data from the fields. Sorting and filtering upon professions came up later.

You are right, I didn't see Pat's answer before. I'm glad you say that, 'cause I was wondering about it. I see, you are proposing of having another, separate table for the parents. I guess it is always a tough decision, depending on how much details from the parents will be needed, isn't it so?

I have this already done. You may want to look at http://www.access-programmers.co.uk/forums/showthread.php?t=93436 about it. I will read about unions and come back if needed. Thanks.