Recent content by jgoodman00

Is it considered Oracle best practice to create new datafiles, or expand existing ones as they become full? Cheers, James

As a SQL Server person, I am trying to recover our live Oracle database to a test server just to prove the backups work. We have a weekly full database backup using RMAN, along with the control file and archive logs. I would like to recover the database using the backup, and archive logs onto a...

Hi, If you have a split backend db/frontend app setup (mdb not adp), then it is normally desireable to keep regular users from accessing the backend db directly. However, you might not want to force users to use a password to access the data through the front-end, or you might want to give...

http://www.j.goodman.dsl.pipex.com/Access.htm#8 Please see this link where I have posted a sample which will probably demonstrate it better... James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Ok: In implementing this here we have the following: A version table containing a VersionNo column, a VersionComments column and a VersionDate column. When the startup form executes, it reads the first record from the Version table, based on a descending sort of the VersionDate column: e.g...

I have encountered this kind of problem so I got around it by including version numbering within the application and DB. Every time an application change is made to the ADP, I add details about this change to my VersionTracking table. When the ADP is opened, a startup form (which runs anyway)...

Yes that is largely correct. I cannot really think of any good online recommendations, but the Inside SQL Server book by Kalen Delaney is excellent. I find myself using it for reference frequently and always keep a copy of the eBook on my laptop. James Goodman MCSE, MCDBA...

Can you describe the setup in more detail? Is the button event executing a SQL Statement, or simply attempting to save the record (DoCmd.RunCommand acCmdSaveRecord) etc? James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

I always prefer to write my update statements in QA. If you make a mistake in Access, it normally just gives 'ADO Error'. If you make the same mistake in QA, it gives you the proper error message. Personally, I love using Access to create select statements, but I prefer to write...

This behaviour is by design. A table without a PK will not be editable in an ADP. You can however insert/update/delete records by executing SQL statements. James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Not that I know of. I am guessing you need to do this because the DSN could be used by read/write users as well as read-only users? This being so, either use User DSN's (a bit of a pain), or how about switching to Windows Authentication & a direct connection to the DB? James Goodman MCSE...

Just realised I had written an FAQ on this subject: faq181-1309 You can disable the shift key by setting the AllowBypassKey property. This can be done via a macro or VBA code. James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Thats it! Tools, Options, Windows In Taskbar. If you disable this it should solve the problem. James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Which version of Access? Using Access XP: I just tried it on a new adp (existing SQL DB). The only startup option I changed was 'Display database window' which I unchecked. With just this setting modified, the behaviour is as expected (i.e. min/max does not unhide it). Can you try the same &...

4 for SQL Server, 8 for Oracle I think: http://groups.google.es/groups?hl=en&lr=&threadm=uzK2VqrCFHA.520%40TK2MSFTNGP09.phx.gbl&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26q%3DTCO%2BOracle%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.* James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com