Search results

thank you for your replies Banana. 1. so the .sql is the database of mysql like ms sql has .mdf. So what is this SOURCE that you added Banana? I dont know that SOURCE. So for example I have already create my supplier table and then I have recorded my first supplier information, where does...

1. ok. I will experiment on that. 2. I am thinking that only the manipulation of data like creating report are done in the FE. that is why it is my belief that I only need to create tables in the workbench and all other objects in the FE. 3. I decided to use innodb from now on. 5. On my...

1. So if I am going to create tables in a database, where can I find it? Where is that data folder? 2. I thought so. why do I need to create relationship and view other than tables while I can create them on Access FE. 3. I see. the default made there was InnoDB. But what engine do you...

Good Day Banana, Hi, yesterday I have explored for the first time mysql, using workbench. and I havent done anything major yet, I just explored around the IDE. I have few questions to ask Banana: 1. What is the database file of mySQL database, as access have MDB and ACCDB files? 2. In the...

if I were you, I am not going to make any memo data fields on my database. I have read somewhere that it is one of the causes of database corruption.

maybe we should ask, what is the deeper root why they act as such. we can say, they have been killing this because they were involve in a cult or maybe they have this outburst of emotion that the outlet they chose was to kill people. There are so many factors that can be involve here that we...

got it Banana. Thanks. I am going towards mysql backend. Hoping for your further assistance though. thanks again.

i see. that is why mysql is popular. I have download the requisites that you said to me Banana on mysql, the gui tools, the connector, the mysql 5.1 but I dont know where to start. Is that all that I need to download? Where should I start designing my tables? Is it like ms sql where it is...

Atomic Shrimp gave me link to the sql edition comparison Banana. And it states that only sql express have limited size db and the rest have unlimited. I dont know much about sql. So I have this questions please. 1. Is it true that sql server express only have 4 gig limit? 2. If I am to...

To Atomic Shrimp on Post No. 12 what do you mean 4 gig limit? 4 gig limit in sql server express? To Atomic Shrimp on Post No. 13 1. What are the data types that are not supported? Were you able to know that? 2. So when you linked the tables from 2007 to 2003, it really did appear as...

uhmmmm....i see. I will experiment on it again. And Banana, do you know that there is a new application now in the internet that is able to crack 2007 database password encryption. I just got it yesterday and it disappoints me. Somehow I am now considering to SQL express.

yes that is linking frontend 2003 and backend 2007. I was thinking of the possibility of using 2007 as backend because of its database encryption. that way, I can set aside my other posts on "security....is there another way". As I have been experimenting on it, though we can bind the...

as per research on the internet and upon experimenting, I found out that I can connect the frontend 2003 to version 2007 tables using ADO thru VBA. 1. I cannot use DAO 2. I cannot use link tables using dao or ado 3. I cannot use link tables using odbc Therefore, I think I would rather...

anyone please.....how about from atomic shrimp!

i think I have a post here in the forum a sample on how to convert report to pdf......check it out. search for pdf

1. how can you say identical? 2. why do you want to sum all the records? 3. What part of the tables you want to sum ?

1. I just want to use 2007 database to make tables for data storage. 2. I want to use 2003 IDE as front end 3. I dont want to use other 2007 features aside from having it as data storage. 4. I want to use 2007 database as storage so that it has better encryption. I can utilize the 2007...

hi, can I use version 2007 as backend and 2003 as frontend? thanks.

so what would you advice me. I want to get all the features aside from being the developer? should it be enterprise or standard or professional?

why is the developer edition far way cheaper than the standard or enterprise edition? I was planning to have the developer edition thinking it has all the features I need.