Search results for query: *

Thanks for your advice, I've currently developed our application to use SQL Server as an optional back end data store. (Using the cludge of linking tables in access 97). What I'm considering doing is moving the whole application to 2000 AND rewriting it to use ADO (to get the full benefit out...

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...

If you want to use the IIS extensions you'll probably have to install a newer version of IIS.

Alternatively you can use the sp_helpdb stored procedure.

If you don't know, MSDE is basically SQL Server. The only difference is that there is a performance throttler built into the server. (This encourages you to buy the full version when you actually start using it to do something). The other main difference is that it is shipped without all the...

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...

Thanks heaps big T!

Sorry, I was a little rushed when doing this... What I meant was.. I need a way to clone a table's schema programatically, either through a system stored procedure or some other means. I have looked through the archives and have been unable to find a suitable way of doing so. I have also...

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

Office XP contains Access 2002. From the documentation that Microsoft has provided in it's "Developer Product Guide". Files that compile under access 2000 will work natively with access 20002 (xp). "The Access 2000 file format is the default file format for new databases and...

With your sql statement (in jet 3.51 / Access 97 at least) you will need to qualify your dates with a '#'. ie. #01/01/2001# So this would change your SQL Statement to "WHERE [RevisionDate] BETWEEN #" & Forms![frmForm1]![txtStartDate] & "# AND #" &...

Do your clients get the errors "Expression is too complex to be evaluated" when they try to do simple things like select drop downs? Are you using Sourcesafe as a source control provider?

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...

Thanks for the info, but I think I've come up with a suitable workaround. Creating an autonumber is going to cause far more grief than it will solve in a multi-user environment. (I've had experience with the locking that access / jet provides - not too crash hot). Because the SQL Server engine...

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 =...

Guys and Gals, You can't use the Index / Seek methods on linked tables. The way you get around this is to either (1) Come up with a better strategy to obtain your data. (SELECT * FROM EMPLOYEES WHERE EmployeeName = 'blah') (2) Open the database that contains that table and then use the...

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...

Thanks for the info - I think this may be the way to do it. I've had some other problems with the ADOX / SQL Server OLE DB combination. I'm not entirely convinced that ADOX works as well as microsoft says it does. Thanks for your help, lachlna

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 =...

There's no great reason why you shouldn't change the design of a database in code. In many respects - it may be your only option - you're writing a database conversion tool that changes the database schema on a database that you have shipped out to clients - it's not feasible or professional...