Search results for query: *

Hi, My company has a whole load of users running our application using access 97 databases. (The data is linked into a code database which comes in a 2K flavour as well). Recently we have been running into corruptions in the databases on an increasing rate. I was wondering if anybody knew of...

Hi, I'm writing an automatic database backup system for my company. When I want to restore my database to the SQL Server I need to ensure that I have exlusive access to the database in question. I have a way of retrieving the processes accessing the database (from the sysprocesses table in...

Does anybody know of an easy way to clone a table's schema into a new table. Keeping default values, identities intact. Thanks, Lachlan

Heya people, Does anybody out there have any experiece with dealing with transactions in access 97? I'm currently upgrading our access 97 database so that it uses SQL Server as a data store, rather than native access databases. The latest hurdle, which I'm pretty sure I won't be able to get...

I tried looking through old threads and couldn't come up with any information that was helpful.. Scenario - Converting our Access97 database to use linked tables to a SQL Server. Problem - We have a table "blah" with autonumber field "num". The existing code is; set rs =...

I've got a table and I need to delete it's primary key unfortunately I don't know what the name of original constraint is. (Well, of course I can have a look and find out, but I'm doing this through code). I'm looking for a statement similar to (1) ALTER TABLE blah DROP PRIMARY KEY but, this...

I'm currently attempting to modify an existing table's schema. I've created a table, copied data into it, set a bunch of indexes and am in the process of wanting to set a primary key and set one of the fields to use the identity property. VB code example... Set pk = New Key pk.Name =...

I'm not sure if this is the correct place to be posting this - apologies if it is. I've recently been given the task of porting our Access 97 database so that it uses SQL Server. I'm in the process of getting all of our data out of databases (in 97 format) and replicating this data in SQL...