Converting Access to MSDE

[The Stoat]

Hi all,

I'm currently writing a DB that uses the FE/BE setup but is only intended to be standalone.

I was wondering what the consequences of changing the BE to MSDE would be regarding record locking -with a view to using it in a multi-user environment - and the differences in the SQL language used?

Also is it possible to do a silent installation of MSDE if distributing the DB to a third party?

Thanks for any help

TS

 

[The Stoat]

Hi Pat, Thanks for the reply.

As a matter of interest i found this article on the net.

http://www.databasejournal.com/features/mssql/article.php/1494271


The concepts seem to be reasonably straight forward [which is saying something from me ] I would be interested to hear your opinion.

I am aware of the need to reduce the volume of network traffic by using selection criteria. I just wondered when writing code to create a recordset from MSDE whether there are additional options in the sense of record level locking that would be better accessed through ADO.


Thanks

TS

 

[The Stoat]

Hi Pat,

Thanks for the reply. I'm going to have a play with the silent MSDE install and let you know how i get on - if your interested that is - . I think that it would be worthwhile creating some error handling just in case there are conflicts with the recordset routines.

Thanks again.

TS