Also when using the AutoUpdater in an Access Database....when they ask you to use your current database version...do they want the file version(00.0.0000)? or the year version(2002)?

What AutoUpdater are you using?

I will guess the file version... as it's the 'trigger' for the updates...

When i downloaded the AutoUpdater i got an instruction file, a Access97 file, and a Access2k file.
Which one do i use??

The instructions ask for the current database version? And that you should place this as the value in the tblLocalVariables...

Not sure what version???

Are you using the one from the code archive?
This AU will grab the FE version (you will need the table that stored that value), not the Access version.

If you have option of versions, use A2K... you have Access 2002.

If you are using a different AutoUpdater, post the link, I'll check it out.

Here is the one that i'm using..this is what i've downloaded so far...i've built the table but i'm not sure what to put for the value??? The value is the version????

Stuck at this point...

It is the same one...

In the setup form (frmSetup):

The first textbox is for the location of the "master" FE on the server
The second box is for the location of the user FE on the local machine
The third is the location of Access.exe on the machine
Set the Show MsgBox to Yes or No

These are the only ones you need to worry about in the setup form.

In the tblLocalVariables (that needs to be in the FE mdb file) you need to set the version of the FE (1.00.05 for example) in the field called VALUE. Every time you update the FE and want to deploy, update that value... this will trigger the auto update sequence.

HTH

I cant find the frmSetup????

and where do i find the version of the FE???

Its also saying the tblLocalVariables cannot be found...but i have it in the same folder as the FE???



Edited by: dcpikapp on Thu May 11 11:50:01 EDT 2006.

i see i see....i'm trying to jump too far ahead of myself yet...havent put this thing on the server yet..

so all i really need to find is the file version of the FE?
and why the tblLocalVariables cannot be found....

You are the one that is setting the FE file version...

You need to place tblLocalVariables in the FE and link it to the Autoupdater... it is looking for it, and it's not there yet.

yeah but what do i set the FE file version to????

when the updater asks me for the version and the value...what the heck do i put in for the value?

understand how to link...thanks

Edited by: dcpikapp on Thu May 11 12:07:16 EDT 2006.

Edited by: dcpikapp on Thu May 11 12:17:52 EDT 2006.

To whatever sequence you want to use... How do you track changes? How would you like to indicate what kind of changes you applied? Do you want to indicate it?

Start with version 1 (1 or 1.0 or 1.0.0 or 1.0.00 or 1.00.00 ... whatever floats your boat)... and keep incrementing it as you release new versions... create a versioning system if you want... or just increment by 1 every time...

Does this help?

hahah i feel lik e a dork...that totally helps...its like my own tracking device to keep track of my changes..

thank you so much.

No problem... we all have our moments...

Glad to help. Good luck with your project.

hahaha not done yet...hahaha

Now once i put that value in...and want to do an update...all i have to do is change the value..i dont need
to add a new row in the table?....

Also...off the subject...if a user adds new records to the database...is it automatically updated and is able to be seen by other users???

Edited by: dcpikapp on Thu May 11 12:49:05 EDT 2006.

A. Once you release a new FE, all you need is to change the value... you should have only one records in the table.

B. If you application is properly split (BE on server/FE on PC), all should be well with the data... the users will be accessing the shared BE via the local FE.

AWESOME! thats the plan so well see how it works once the server is ready....thanks soooo much...
-o!

You are welcome.

Good luck with your project.