Re: How to convert Relationships into the new Access 2010 format

Albert D. Kallal wrote:
"Bob Alston" <bobalston9@xxxxxxxxx> wrote in message news:laEOm.24742$kY2.15236@xxxxxxxxxxxxxxx

I am sorry for my confusion. I was asking about importing an access 2010 database with various tables like I stated, with relationships. So I really want to import the entire Access database.


Sure, the above instructions apply equally well here to an standard (non web) access 2010. I don't believe the web database will allow the import of the two tables unless you un-check the import relationships option outlined during the import (just try it!). So, I don't see a problem here. If the tables are already web, and have used the new lookup/relationships windows, then when you import them, the relationships will likely move along for the ride.

I don't see any reason why would importing from access 2007, 2003, or even 2010 tables for that mattes changes any of my instructions.

It possible if you have some non published web tables in an application, the import wizard says you can't import **and** upchucking the "import relationships" box fails, but that would be a bug, and it would thus be a simple matter to remove the relationships BEFORE you import in this case (if access says you can't do this - I would just make a copy of the data file, and then just remove the relationship using the lookup wizard *IF* access says you can't import in this case).

So, the fact of importing tables from access 2000, 2003, 2007, or 2010 should not change the above issues and instructions one bit...

I don't think I am trying to do the upload the same way you are explaining. I am trying to share the entire Access 2010 MDB file to Sharepoint, using Access services. I Select FILE then SHARE then PUBLISH TO ACCESS SERVICES. Next I run the compatibility checker. Next I fill in the data fields for server name and site name and click the button for PUBLISH TO ACCESS SERVICES.

I get a failure do to the existence of the table relationships.

what am I missing?

bob
.

Relevant Pages

  • Re: Change Password by User
    ... You may also be interested in the Security FAQ, which provides instructions on ... See http://www.QBuilt.com for all your database needs. ... One may open a specific form when the database opens by running code that ...
    (microsoft.public.access.security)
  • Re: An Honest and Simple Question.
    ... I have done this ad nauseum by way of posts on Mutual database. ... include instructions so they can identify which one of those things ... which takes SPECIALIST MANAGEMENT to follow. ... communication loop could have that problem. ...
    (sci.crypt)
  • Re: [SLE] For or against ..Hyperthreading.
    ... > Let's say for mail or Database server... ... Opteron and Athlon-64 also have a different memory access archetecture so ... - 64-bit Address registers means more memory is directly addressable, ... do a wider range of operations as primitive instructions (for example, fetch, ...
    (SuSE)
  • Re: Shared Drive, Security
    ... Your instructions are the ones I found and followed. ... am not familar with setting up securities and shared drives, ... far I have managed to create a new workgroup different than my default. ... I am also confused about the splitting of the database. ...
    (microsoft.public.access.security)
  • Password Protect an Access 2000 Form Using VB
    ... please excuse the elementary nature of this post. ... on a very simple, "Rolodex"-type database. ... The code instructions work when I use the Northwind sample database, ...
    (comp.lang.basic.visual.misc)