Search results

I would think run-time would allow you to use access apps without needing any additional licencing. Isn't that what run-time is for? Kind of like the powerpoint viewer............

That's a great point - I didn't even think of that. And hey, the onClick event worked PERFECT (not sure if you read the edit to my post). Thanks again for your help - you saved my demo - I was wigging out since I never tested on runtime before late last night. THANKS AGAIN !

Wow, thanks for the quick reply!! Let me ask you, I actually am Looking to disable ALL warnings....delete records, update records, etc etc.....do i need to one of these for every single button in my app or is there a way to set it once when the app loads to disable warnings across the board...

My users are using my app with 'ms access runtime 2003'. I have not been able to figure out how to disable the warnings for 'delete, update, action' on their machines running access runtime. Would this resolve my issue? Where exactly would I place this code? Any help would be GREAT as I...

hey, thanks for the reply.

With access runtime installed on the Term Serv... Would putting an actual physical copy of the FE in each user profile's directory and then storing the BE on the same Term Serv computer where everyone is logging into be the appropriate way of doing this? (using group policy to lock down the...

Good deal. Hey thanks again for everything!

You were def. major help in piecing it all together. Do you have the code or a sample of your method for the logins posted on the forum?

Now i see what you are saying. On a side note, Let me ask you.....if you use dsn-less connection for access to the tables on the sql server. Do the tables still show up as linked in the linked table manager? Or are all tables connected via the coding?

I see. So what you are saying is that if the sql pw is not saved then if they are NOT logged in and they created a blank db to import from the .mde file they have on their client machines....they would not have the access to import the tables.....

I used sa just for development...i would def create a new user at time of distribution. You mentioned once you create .mde you cant do anything....however that only secures your forms, macros, reports, pages and modules...you are still able to import the tables and queries.....

I don't wany anybody to be able to get at the data without having to supply sql credentials.... In other words unless it's myself or the owner specifically authorizing that an individual need access to the sql db to run crystal reports or use excel, etc. I dont want anyone with general access...

When initially upsizing, i used sql auth only. And I simply logged in as SA when it prompted....However, I did NOT save the password. I honestly planned on just logging in manually as sa when I distributed this front end onto each user machine........I know it is VERY impractical......but that...

Did I satisfy my objective with my last NOTE ? :confused:

I made the entire db and interface all in one acess 2003 db. I then upsized the db to sql server 2005. Now i have a front end in access 2003 and the tables are linked to sql server 2005 tables (i believe this is DSN connection via odbc driver, correct? and please correct my terminology if wrong)...

whooooaaa....2 year old post...i feel like an idiot

I just recently used the upsize wizard for the first time and it actually preserved all of my original table names.......they just show up linked with their original table names. However, in the SQL db they do have the dbo prefix. Hopefully this helps at all...(even though just a regurgitation...

HELPED ME OUT TREMENDOUSLY IN UNDERSTANDING MDW. THANK YOU. ON A SIDE NOTE... I dont understand why Access doesn't have a more straightforward and secure "security" principle. *Why there is no option to prompt for credentials if someone wants to link to the tables of your access db or...

Microsoft support page has a page on disabling shift key. I have tried it and it works. Here's the link: http://support.microsoft.com/kb/826765

Thank you from me too! You guys resolved my problem on a similar issue I was having naming images to the record ID. Came across on a search. THANKS!!