To update each computer, I created a proc to update the database. It is pretty simple :

1) Create a global variable in your project which contain the version number of...

I've been working with ADP for 2 years now (I tranfered an old access 97 mdb to sql server). The application is installed on more than 50 desktop and is...

I've seen a good series of articles on version control in sql2k on this site by Steve Jones. Here's the link, maybe it can help you...

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

Eric

Never tried it, but I guess if you shedule 3 jobs that runs each 1 minute with a 20 second difference, it should work.

1st job : starts at 00:00:00 and...

My current system is easy to implement. I've got a scanner that scans the bar code into text fields in ms access (it is plugged in the keyboard). Access sends it...

Thanks, I runned the decompile command and it worked well!! Believe me, I had try everything else!!

I couldn't use my backups cause it my developement apps and it began to do...

Use system_user. It returns domain\user.

You can put it in a user defined function to be able to use it in a query :

my function returns a varchar(50) to be sure...

I still think that there is no need to give shit to this person. If you don't want to answer newbies question, just don't. Nobody force you to. I don't...

Thanks everyone for your reply on a sooo long message. I'll look at your ideas and take the best one that fits my current database design.

Thanks again!

That's what I did, I let the maintenance plan run as usual.

I did this a couple of month ago.

It doesn't change anything. Before doing so I checked my data to be sure nothing changes (my database is in french), and nothing...

I had the same problem about 2 years ago. We had a MsAccess database that was used on about 30 desktop (very very slow!!) so I had to transfer that...