Re: Appending a field to a table -AND- accessing a split back-end

Thanks again Allen.

Your link "Tony Toew's article" was also helpful.

Regards,
Michael


"Allen Browne" wrote:

> Someone else may have a better answer for this 2nd question than I.
> Hopefully they will contribute.
>
> IME, you are very likely to run into this problem if the linked tables have
> been used at all, and that's almost always the case in an fe/be arrangement.
> I guess you could try deleting all the linked tables, waiting for the
> timeout period (however long that is on the operating system), then seeing
> if you can get an exclusive lock, running your code, and then creating the
> links again.
>
> What I prefer to do is to create a separate "updater" mdb to perform the
> updates. It has no linked tables, and asks the user for the location of the
> back end file. It will then OpenDatabase exclusively, and perform the
> changes, logging each step, and showing a report of the errors if anything
> did not complete as expected.
>
> I am assuming the goal here is to update a back end database to a later
> version at a remote site where you cannot perform the changes yourself.
>
> Not sure if Tony Toews' article will help:
> http://www.granite.ab.ca/access/backendupdate.htm
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B2292741-90EF-4C1C-A766-DD4B5BF68CDC@xxxxxxxxxxxxxxxx
> > That completely answers my first question. I thought that I could append
> > precision and scale as properties to the field, but since I can not create
> > a
> > field with the data type decimal programatically, that ends before it
> > begins.
> >
> > Thank you Allen.
> >
> > I do not think that I conveyed the second part well...
> >
> > I am working in the front end of a split database and I want to modify the
> > back-end by adding tables and querries progamatically. If I declare a
> > database variable and try to set it to the OpenDatabase() method for my
> > back-end DB I get an error stating that the back-end is already open
> > exclusively by admin. I did not open the database programatically or
> > otherwise at this point, except that the tables in the front-end(which I
> > am
> > working in) are linked tables who's source is in the back-end, and fields
> > from those tables are used on my front-end form.
> >
> > I want to create a variable that references my back-end, or use whatever
> > access is using(since it seems that access is the one who is opening the
> > DB
> > exclusively). I would have assumed that it would show up in Workspaces,
> > but
> > I can not find it there either. There is nothing for me to dispose of,
> > because I have not managed to create it yet.
> >
> > If you were to create a database(Test.mdb) with a table(tblTable) in it
> > that
> > had a field (fldField) and then you were to create a form(frmForm) with
> > tblTable as it's record source and add fldField to it and place a command
> > button on it. Then use the Database Splitter under Tools->Database
> > Utilities
> > to create a back-end(Test_be.mdb), which your table(tblExample) would now
> > be
> > in. Now if you wanted to add code to the command button on frmForm in
> > your
> > front-end that added another table(tblNew) in your back-end. What would
> > the
> > code be for the command button. Assume both database are on c:\
> >
> > Thanks in advance,
> > Michael
>
>
>
.