Search results

I have never found a very reliable way to keep people out of the queries. You can keep them out of forms and reports by making the database an MDE or ACCDE, this would also keep them out of the code as it is compiled at that time. What I've done to keep people from making changes to queries is...

Open a VBA module, on the tools menu you should see several options, there should be one like YourDatabasename Properties... Click this, go to the second tab called protection. Click the Lock project for viewing, then enter a password below.

The table you're showing has no data, the row you have highlighted is a new row, what would there be to copy?

So basically your client wants to use, manipulate, and access a database created in MSACCESS, but not use any available tools that would allow them to do so. Your client wants the same capabilities as the Citrix server offers but doesn't want to use Citrix...your clients demands are ridiculous...

The only time I've seen this issue happen, is when we converted to Windows 7, Oracle didn't like the Program Files (x86) folder path, if the office path was changed, or Access was launched with a shortcut that removed the parenthesis from the path it was ok.

Do you know what version the Oracle database is you're trying to connect to, is it version 9, 8, 7, etc?

has anything changed other than the drivers? New OS, new office, etc?

try this site http://www.bettersolutions.com/vba.aspx

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-511#fbid=zzQiHnPd3Sh If you look at a lot of the .NET 4 tests you get the choice of language when you take the test, they just don't have them as separate tests any more.

Ah, I'm using the full path to the application, so rather than start, I'm using "C:\Program Files\<InsertOfficePathHere>\MSACCESS.EXE" "database Path here"

I do not have this issue on my 2007 or 2010 machines, how are you launching the applications?

Office programs cannot natively play the mp3 format which is why you haven't found much about it. You can embed a media play control and use that to play files, or convert them to WAV files and use the windows sound APIs to play the files.

http://www.access-programmers.co.uk/forums/showthread.php?t=123807 Try this thread

Yup, happens from time to time, try going to debug and press Clear all breakpoint, this usually works for me. If that doesn't work, copy and paste the code onto a new line, then delete the old one.

Individual permissions maybe? Are you part of a power user or admin group, or are they part of a different user group?

UAC - User account control is the nice little feature Microsoft added in Windows Vista, the annoying popups that happen everytime you run a program that can potentially change something on your system...

2 machines being imaged the same way does not mean they are still currently the same. It sounds like UAC was turned off on one of the machines.

You could try the Access 2010 runtime, that should be able to run your database.

Save it as a 2007 / 2003 format and that should work, of course you cannot use any controls or abilities introduced in Access 2010 either.

You might try on the Zoho creator forum. https://forums.zoho.com/topic/zoho-for-ms-access-users