Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


ajobbins

5053 posts

Uber Geek
+1 received by user: 1279

Trusted

#28404 28-Nov-2008 14:51
Send private message

Does anyone know if it is possible to view MS Access data access pages on a PC that does not have access installed?

Create new topic
zocster
1994 posts

Uber Geek
+1 received by user: 105

ID Verified
Trusted
Lifetime subscriber

  #180948 28-Nov-2008 16:21
Send private message

There is a viewer but not sure how good is the snapshot viewer is.



wazzageek
1095 posts

Uber Geek
+1 received by user: 108

ID Verified
Trusted
Lifetime subscriber

  #180988 28-Nov-2008 22:34
Send private message

Depending on your circumstances, you may be able to utilise the JET Database engine from Microsoft too - this makes it possible to access data from other sources - web pages, vbscript and iirc the likes of excel.

 

Of course, you *might* be able to utilise the free SQL Server express edition to accomplish what you want (I've not played with SQL Express since it came out - my mind is a little rusty.)


ajobbins

5053 posts

Uber Geek
+1 received by user: 1279

Trusted

  #180990 28-Nov-2008 22:37
Send private message

Issue is that we have an existing database, but a whole bunch of new users who need to use it and who don't have access installed. Getting access installed is a no-go because the licencing costs outweigh the percieved benefits.

So I need a way of accessing (and changing) the data without forking out for a bunch of licences.



wazzageek
1095 posts

Uber Geek
+1 received by user: 108

ID Verified
Trusted
Lifetime subscriber

  #180992 28-Nov-2008 22:53
Send private message

The webmonkey in me simply suggests setting up a webserver and some form of web script (ASP / .NET / PHP) and utilising ODBC back to the source database.  No need for access to be installed at all, plus the adding bonus of sending out a URL to all and sundry to access.

Of course, this assumes you have the capacity to drop this in place and all machines are connected back in real time to the central source of the data (no offline usage here)

- I've certainly accomplished this before in the past using Windows, JET, ODBC and PHP pages (usually server via IIS).

Hope that helps.


zocster
1994 posts

Uber Geek
+1 received by user: 105

ID Verified
Trusted
Lifetime subscriber

  #180996 28-Nov-2008 23:01
Send private message

May be this can help?

wazzageek
1095 posts

Uber Geek
+1 received by user: 108

ID Verified
Trusted
Lifetime subscriber

  #181000 28-Nov-2008 23:14
Send private message

zocsters suggestion sounds good - although there could be issues for you if you want to restrict what users can and can't alter. 


 
 
 
 

Shop now for Dyson appliances (affiliate link).
itxtme
2102 posts

Uber Geek
+1 received by user: 557


  #181177 29-Nov-2008 21:49
Send private message

When money is tight go for the free version :D

 

http://www.openoffice.org/

 

More specifically ->http://why.openoffice.org/images/base-big.png


ajobbins

5053 posts

Uber Geek
+1 received by user: 1279

Trusted

  #181225 30-Nov-2008 13:06
Send private message

itxtme:

When money is tight go for the free version :D


http://www.openoffice.org/


More specifically ->http://why.openoffice.org/images/base-big.png



Looked at that already, but OpenOffice dones't like .mdb files so I would have to start from scratch.

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.