Search results for query: *

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

Correct, it will only allow you to select counters that were actually recorded. To create a console: Open the perfmon console (Administrative Tools, Performance) & configure it as you would like. Then select File, Save As. You will then be able to save the console as an msc file. Opening this...

The only way in EM is to manually change the Filegroup for each table (you could create a new filegroup with a single file). This could be very laborious if you have a lot of tables! Is there a specific reason why you want to delete 3 of the files? Was there a reason for having 3 files? In a...

The clustered index will dictate the physical ordering of the data, but you can use ORDER BY to sort your data as you wish. Assuming the sequence you included above is some kind of number type (e.g. int), ORDER BY will place the records in order. James Goodman MCSE, MCDBA...

Not that I know of. A kind of workaround is to create a custom console which you can then save. This will retain the counters you choose to view & I think this works for multiple files. James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Not sure about visibility, but by removing the [guest] user from each database you can stop them from viewing the objects within. James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com