Windows 10: I want my wife to have access to my account so she can access Microsoft word

I want my wife to have access to my account so she can access Microsoft word

:)

 

User accounts in VB2005 from MS Access

Access has a list of words not to use as column names, but if you must, you'll need to use brackets in your sql statement. I'm unsure of the list of words, but the line of code appears valid. Try using this:

Dim sqlString As String = "INSERT INTO USERS ([USERNAME], [PASSWORD]) VALUES ('" & usernameString & "', '" & passwordString & "')"

Perhaps its password that's causing the issue.

You could also try renaming the columns within the access database. I ran into this issue when I used the word time as a column name.

 

MS ACCESS: A7 Building Queries in Microsoft Access

Hello, I'm having problems with creating a database from this questions. I was able to do get to a point but won't show or missing something. Can anyone help on these questions:

2. Display the CustomerNum, CustomerName, OwnerName, Phone, RestaurantType, and FirstContact of customers who were first contacted in 1992 and 1993. The list should be sorted by the FirstContact date (with the most recent at the top) within RestaurantType in ascending order.

3. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

4. Write this query in SQL. It should be your SQL code and not the one generated by Microsoft Access. Show the CustomerNum, OrderNum, and InvoiceAmt for orders that were placed by customers with CustomerNum in the 500s (that is numbers that fall between 500 and 599) or valued at $2,000 or more. Sort the list by CustomerNum in ascending order.

5. Show the CustomerNum, OwnerName, Kitchen Area, InvoiceAmt, and ZipCode for customers who are located in ZipCodes starting with 43 and have InvoiceAmt between $1,200 and $2,000. The list should be sorted by CustomerNum.


Attached is the File on a zip as access file is not accepted.
The queries I'm working from that I made for some of these are Customer Query, Restaurant Type, Order Query 1.
Thanks this will be a lot of help as I've been trying to do this for the last 3 days.

 

Recover access database

Looks like you will need to rebuild the whole thing but at least you have the data still, right?
EDIT: Wait did you try this?

Convert a database to the Access 2007 file format

http://office.microsoft.com/en-us/a...-the-access-2007-file-format-HA010048406.aspx


You cannot convert a replicated database to the Office Access 2007 file format. However, you can use Access 2007 to create a replica of a database that is formatted in either the Access 2000 or the Access 2002 - 2003 file format.


More copy and paste:
[paste:font size="5"]Convert an Access 97 database, Convert an Access 95 database, or Convert an Access 2.0 database.

• Click the Microsoft Office Button
  
  , point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.

• If any database objects are open when you use the Save Database As command, Access prompts you to close them prior to creating the copy. Click Yes to make Access close the objects, or click No to cancel the entire process. If needed, Access will also prompt you to save any changes.

• In the Save As dialog box, type a file name in the File name box, and then click Save.

Access creates the copy of the database, and then opens the copy. Access automatically closes the original database.

Here is a short and sweet version: http://www.ehow.com/how_7339817_convert-2003-database-access-2007.html