Search results

Let us have this scenario: Frontend - MS Access Backend - SQL (due to its security and size capacity) However, due to its complexity and architecture, there is a daemon that is necessary to connect Access to SQL like ODBC (DSN). Why not Microsoft simplify the connection of Access to SQL to...

the difference between desktop database and server database is their ARCHITECTURE that they were made. That is why I asked, WHY NOT engineer or make the architecture of Access database like sql server database in terms of Connection and Size Capacity. Like in a Car analogy: why not give the...

As I posted on number 6, I have these points: 1. Dont we have someone from Microsoft for us to contact or have forum with take he or she may answer the questions that only them can answer? 2. As I indicated there, it is true that perhaps 2 gigabyte will probably run long in time and...

all that you have said banana were true. when I explored filemaker last night, it is far from access in terms of vba, creating tables, queries, sql, forms, report and macros. Access has much more tools to create the database. However, I am really puzzled how the heck the database of filemaker...

1. as I can recall, jet was renamed to ace simply because they were handled exclusively now by access production team. 2. that is so true shadow. not all access programmers are in-depth knowledgable in sql nor much to vba and even to sql servers or mysql server for that matter. sql servers...

I have researched about Filemaker pro, thought I can say their IDE is not very user friendly and their script compared to vba is not very much powerful and their find compared to query is not very much extensive However, I find that their database size limit is 7 terabyte and has simple good...

just open it to launch a separate access window with the database opened into it. NOT link or import. was my code above sufficient or not yet?

yes I do know the password because it is my work Dcrake. can you teach me how to do that or what that vba code is..... I have found this but i dont know if this is............... Option Compare Database Option Explicit Sub OpenPasswordProtectedDB() 'Define as Static so the instance of...

I have two database A and B. database A is password protected. How or what is the VBA code that I can make in a command button that in Database B that will open the database A (not link the table) application? I not that good at vba. thanks.

ok. so base on your wants and needs, can you say what would be your best pick for desktop and server database? The reason why I was asking is that, i think that you and other people here maybe more familiar that me from those kinds of database. So to be able to decide which I would also choose...

can we just give our own opinion on what is the best desktop and server database? I know there are alot of factors that can affect judgment but just in general or just first choice! thank you.

what is the best desktop and server database?

couldn't you include a readme text file in your application or zipfile for any instructions for your program?

thanks for the reply Boblarson. Yes I agree that the use would need to supply the password. But can it be automated using VBA to automatically supply the password so that it will open normally without showing the password dialog box prompt? so that only the startup form will open?

Hi, Case: I am encoding itemname and itemqty in a form. Output: what I would like to achieve is after encoding the two fields, I will be able to print them by line and not like ordinary printing wherein when you print, the whole page of paper will be fed out of the printer after printing...

yeah. I was very amazed how western culture is so open on sexuality being portrayed in Big Brother show. Making sex is all over the place. It is as if, showing sexual intercourse in the public for viewing is just ordinary. Isnt there lose of morality? As a result, even minor aged girls and...

I intend to put database password and encrypt the Front-End of access 2007. Is there a way that I can open the front-end without the database password dialog box prompts to enter the password like using vba ?

No. I have not yet tested it myself yet. I was busy reading books and other references. So there is NO WAY for them to open the tables from the FE ! please confirm....thanks. I would add something more. For example, the FE (database B) also have its own table (not linked). So since this is...

I have not tried it yet. I am going to use 2007. I am going to just secure the BE (database A) with database password and encrypt it. So with my FE (database B), I am going to link it, but I am afraid that with the FE, they can open the link tables there using other database (database C)...

thanks for the quick reply. I have considered ULS. do you have other suggestions? How about if I am using version 2007?